Prepare to change your company’s reporting game forever! We know that data is not usually stored in nicely curated databases and often - even when it is - the data analyst doesn’t have access to it. Instead, we must piece together data provided in text files, Excel files, web pages, and even the body of emails to build the business intelligence solutions we need. Until now this has been a painful process with a great deal of cut and paste effort, and updates have been tedious and error prone. That stops with this workshop!
In the Self-Service BI Boot Camp we'll dive into:
a deep exploration of Power Query for gathering and preparing your data
the benefits, concepts, and key terminology of Dimensional Modeling.
how to create a variety of DAX measures, understand how DAX measures are calculated, and how to control their Filter Context
calendar intelligence, including building calendar tables, using the “Golden Date” pattern, and extending our model to report based on our own year-end
specific features of Excel and Power BI that every analyst should know, which tool is right for the job, and how they can be used together in one solution
Come and join us for this hands-on workshop that will revolutionize your reporting process! Visit the Excelguru website for full course details and registration.