RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Walk-through Steps: I’m New to BI, Where to Start? – Part 2: Modelling with BISM

16227346893_7645a5f6f1_z

You’ve learned about first steps for getting into BI field in previous post. In this post I’ll continue with explaining some other components of Microsoft BI and resources to learn it. Previous post was about the overall picture of BI, Data Warehouse Design, Dimensional Modelling, ETL and SSIS. In this post I’ll explore components such as SQL Server Analysis Services (SSAS) Tabular and Multi-Dimensional.

[…]

Walk-through Steps: I’m New to BI, Where to Start? – Part 1

13903368609_760b4b4767_z

Business Intelligence is hot topics still after years of first appearance of the world in the job market. Term changed many times; Data Warehouse, Business Intelligence, Data Analysis, and Cloud BI…. BI related jobs are still high paid jobs in the market. Demand for BI is pretty high, and number of BI professionals is not that high. So it creates a niche market section for high demand jobs with high salaries. On the other hand BI is not something out of the blue for DBAs, Database Developers, Software Developers, and many IT professionals. Most of software developers build reports and analysis elements on their everyday activities. However that experience in report writing and analysis isn’t that much helpful for them if they want to step into BI jobs. For getting into BI market, you don’t only need experience in report writing, but you also need conceptual and architectural points of BI and DW systems, understanding components of BI, and learning tools of it.

[…]

FIFA 2014 World Cup Data Analysis with Power BI

2405348_xbig-lnd

Fifa 2014 is not a hot topic these days, but it was the headline news June 2014. With new capabilities in Power BI Designer I tempted to use FIFA 2014 Worldcup data as a demo of it, and play with the tool to see how it works. Fortunately I was able to build some interesting dashboards with it. The demo work was interesting enough to say that I probably would write detailed information about how to build such demo, and would use it in some of my conference speakings.

I’ve used data from official Fifa.com website for most parts of this demo. you can reach FIFA.com official site for 2014 Brazil from here:

[…]

Azure Data Factory – Updates: March 2015

Previously in another post I’ve mentioned what Azure Data Factory is and a sample scenario of data transfer with it.

Microsoft recently published a new version of it, which has really interesting features. In a nutshell features are:

  • New Version of Data Management Gateway
  • On Premises File System Linked Services
  • On Premises Oracle Linked Services
  • Encoding options for text files on Azure Blog storage
  • Invoking Stored Procedures with additional parameters.

Have a read in details about these new features below;

[…]

Full Day Training Pre-Con: Power BI from Rookie to Rockstar

Full Day Training of Power BI with the title of Power BI from Rookie to Rockstar has been ran in SQL Saturday Vienna.

RADACAD presented one pre-con on Power BI, and couple of sessions; A Journey to Power BI by Leila, and ETL on Cloud? Azure Data Factory by Reza.

Power BI pre-con includes Power Query, Power Pivot, Power View, Power Map, Power Q&A, and the new Power BI Designer.

[…]

SQL Saturday Vienna 2015- A Journey to Power BI

To download the Session slides click below link : A-Journey To Power BI My session   God turn out in SQL Saturday Vienna   An Interesting Keynote speech by Mark Souza    Have fun the day after SQL Saturday around Vienna with other Speakers     I have Talked about Power BI in SQL Saturday Vienna , Special Read more about SQL Saturday Vienna 2015- A Journey to Power BI[…]

SQLBits is Awesome, But I cannot Attend! Why?!

It is with all regret that I cannot attend at the conference that is the largest SQL event in Europe, and always compared to SQLPASS Summit because of the high quality of content and large number of audience. I was honored to be selected to speak for couple of sessions in SQLBits 2015, and I Read more about SQLBits is Awesome, But I cannot Attend! Why?![…]