%Article_Title%


%Article_PostTime%
%Article_Att%
%Article_Desc%
%Mate_Title% Our Work
%Mate_Title% Our Blog

Read about latest technologies, our team's experience, and thoughts, best practices, and real world solutions, from our frequently updated blog.

Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX

Parent-child functions in DAX are very useful for parsing an organizational hierarchy or something like a chart of accounts. Usually, for hierarchies that the number of levels is not determined, you need to use a different method, and parent-child functions in DAX are a big help for that type of hierarchies. In this post, you ...

Read More

Week to Date Calculation in Power BI with DAX

There are a number of pre defined DAX time intelligence calculations that help you to get analytics over time, such as year to date, same period last year, and etc. However, there is no calculation for Week to Date built-in. I have found it quite a demand for some of businesses, as many of businesses ...

Read More

Quick DAX : Convert number to binary (and back)

Something that is currently missing in DAX is a native set of functions to perform Bitwise operations.  These can be incredibly useful functions and one, in particular, is the ability to convert a  base10 number to its binary format. Once you have the number in binary format, you can apply logical operations between numbers to ...

Read More

%Mate_Title% Our Clients Love Us

What our clients say about our service and solutions

  • “I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

    Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

    After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

    I would recommend Radacad Power BI Training without hesitation.”

    Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools
  • “Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.”

    Dan Cheshire, Senior Project Manager Air New Zealand
  • “We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!”

    Sonia Buckley, Data Analyst at Zoom2u
  • “I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.”

    Martin Catherall – Data Platform MVP, PASS Regional Mentor

%Mate_Title%

%Mate_Title% Meet Our Team

Our team of experienced consultants, and mentors, with high level qualifications in their field and many year's experience would love to help you.

Reza Rad

Reza Rad is an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for seven continuous years (from 2011 till now) for his dedication in Microsoft BI.

Leila Etaati

Leila is Data Scientist, PhD, MVP, and BI Consultant, and Speaker. She has over 10 years’ experience working with databases and software systems. She was involved in many large-scale projects for big sized companies. Leila has PhD of Information System department, University of Auckland, MS and BS in computer science.

Philip Seamark

Phil is Microsoft Data Platform MVP and an experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft B.I. stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling.  He has 25+ years experience in this field and an active member of Power BI community

Don’t hesitate, should you have any inquiries

Contact Us

Give me free Stuff!
Sort Options

Sort By:

date

Date

Online
16jul - 20All DayPower BI from Rookie to Rock Star – US West July 2018
Event Details

Register Here Course Title: Power

more

Event Details
Register Here Course Title: Power BI from Rookie to Rock Star Length:

Online: 5 days (Lecture + Labs) – 5 Modules; 1 day Essentials (Module 1), 4-days Advanced (Modules 2-5).

Instructor: Reza Rad

In this training course you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Components such as Power Query (Get Data and Transform), Modeling and DAX, Visualization, Power BI Desktop as the main tool, Power BI Service, Gateway configuration, and architecture. You will learn all the concepts with live demos. Expect learning best practices with great scenarios in this course.

Online

Time in your area

Start: Monday, July 16, 2018
End: Friday, July 20, 2018
Time: 9:00am – 4:30 pm ADT

Suitable time for these cities:
Acapulco, Adak, Adamstown, Aguascalientes, Albuquerque, Alert, Alofi, Anchorage, Asuncion, Atlanta, Augusta, Austin, Baker Lake, Baltimore, Basse-Terre (Guadeloupe), Basseterre (St. Kitts), Belém, Belmopan, Billings, Bismarck, Blanc-Sablon, Bogota, Boise, Boston, Bridgetown, Buenos Aires, Calgary, Cancún, Caracas, Castries, Cayenne, Charleston, Cheyenne, Chibougamau, Chicago, Columbia, Columbus, Concord, Coral Harbour, Córdoba, Dallas, Denver, Des Moines, Detroit, Dover, Easter Island, Edmonton, Eureka, Fairbanks, Fort-de-France, Fortaleza, Galapagos Islands, George Town (Cayman), Georgetown (Guyana), Grise Fiord, Guadalajara, Guatemala City, Guayaquil, Halifax, Hamilton, Happy Valley-Goose Bay, Hartford, Havana, Hermosillo, Honolulu, Houston, Indianapolis, Inuvik, Jackson, Juneau, Kansas City, Kingston, Kingstown, Knoxville, Kuujjuaq, La Paz, Las Vegas, Lima, Lincoln, Little Rock, Los Angeles, Louisville, Madison, Managua, Manaus, Mazatlan, Mexicali, Mexico City, Miami, Midland, Midway, Milwaukee, Minneapolis, Montevideo, Montgomery, Montpelier, Montreal, Nashville, Nassau, New Orleans, New York, Newark, Oklahoma City, Orlando, Ottawa, Panama, Papeete, Paramaribo, Pensacola, Philadelphia, Phoenix, Pond Inlet, Port-au-Prince, Port of Spain, Portland, Providence, Punta Arenas, Québec, Quito, Raleigh, Rapid City, Rarotonga, Recife, Regina, Resolute Bay, Richmond, Rio Branco, Roseau, Sacramento, Saint George’s, Saint John (CA – NB), Saint John’s (Antigua), Salem, Salt Lake City, Salvador, San Diego, San Francisco, San Jose (CR), San Jose (USA), San Juan, San Salvador, Santiago, Santo Domingo, Seattle, Sioux Falls, St. Louis, St. Paul, Stanley, Sucre, Tegucigalpa, Thule Air Base, Tijuana, Topeka, Toronto, Unalaska, Vancouver, Veracruz, Washington DC, Whitehorse, Winnipeg, Yellowknife

Power BI from Rookie to Rock Star

This is the most comprehensive course for Power BI which split in daily modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are list and detailed agenda of each module:

  • Module 1: Power BI Essentials
  • Module 2: Advanced Power Query and Data Transformation
  • Module 3: Advanced Data Modeling in Power BI with DAX
  • Module 4: Advanced Data Visualization in Power BI
  • Module 5: Advanced Gateways, Power BI Service, Administration, and Architecture
Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.
1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source
1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M
1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced
1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization
1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways
1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh
Module 2: Advanced Power Query and Data Transformation in Power BI

This course is module 2 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Agenda;

2.1: Get Data
  • Different Data Sources
  • What is Power Query?
  • Power Query in Excel and Power BI
  • Basic Transformations
  • Get Data from Web
2.2: Query Editor
  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from SQL Server
  • Get Data from CSV Files
  • Get Data from Excel
  • Get Data from JSON
  • Transformation Pane
2.3: Power Query Syntax
  • Data Types in Power Query
  • Query Properties
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
2.4: Combine Queries
  • Merge, Joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder
2.5: Transformations
  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Add as new query / Drill Down
2.6: Table Transformations
  • Group By
  • Extending Group By with Expression Editor
  • Transpose
  • Pivot, Unpivot
2.7: Text Transformations
  • Split
  • Merge (Concatenate)
  • Parse
  • Extract
2.8: Numeric Transformations
  • Standard
  • Scientific
  • Statistics
2.9: More Transformations
  • Date Transformations (Year, Month, Quarter)
  • Extending Fiscal Date Column
  • Time Transformations
  • Adding Time/Date banding
  • Structured Column
  • Expand
  • Aggregate
  • Add Custom Column
2.10: Power Query Formula Language: M
  • What is M? and the importance of learning M
  • M Syntax
  • Things to Consider for M Scripting
  • Basic examples of M
  • Values in M
  • Logical Operations
2.11: Advanced M Scripting
  • #Shared Keyword; function library of Power Query
  • Parameters
  • Custom Functions
  • Error Handling in Power Query
  • Generators in Power Query: Implementing Loop Structure
  • EACH singleton function
2.12: Use Cases
  • Date Dimension with Power Query
  • Day Number of Year Custom Function
  • Looping through files in a folder with Power Query
  • Online Date Time Scheduler with Power Query
Module 3: Advanced Power BI Modeling and DAX

This course is module 3 of the Power BI from Rookie to Rock Star course.

In this course, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Agenda;

3.1: Power BI Modeling 101
  • Relationship in Power BI
  • Relationship based on multiple Columns
  • Role Playing Dimension
  • Formatting
  • Hide/Unhide
  • Hierarchy
  • Basic Calculated Column and Measure
  • Sort by Column
3.2: Introduction to DAX
  • Syntax of DAX
  • Naming in DAX
  • Logical Operations
  • Data Types in Power BI Model
  • Overview of Functions
  • Variables
3.3: Functions in DAX in Details
  • Text Functions
  • Information Functions
  • Logical Functions
  • Date and Time Functions
  • Aggregation Functions
3.4: Filter, Value, and Relationship Functions
  • ALL
  • Examples of using ALL function
  • Filter Function
  • Related
  • RelatedTable
3.5: Evaluation Contexts
  • Row Context
  • Filter Context
  • Exception for Row Context
  • Exception for Filter Context
  • Calculate Function
3.6: Time Intelligence Functions
  • Year to Date, Quarter to Date
  • Fiscal Year to Date
  • Same Period Last Year
  • Running Total
  • Rolling 12 Month Sales
  • Average 12 Month Sales
  • Rolling 6 Months
  • Flexible banding
3.7: Calculated Tables
  • Role Playing Dimension
  • Top 10 Customers
  • More Scenarios of Using Calculated Tables
  • Performance Consideration
3.8: Best Practices Tips and Tricks
  • Solving DAX Now and Today Time zone Issue
  • Modeling Best Practices
  • Advanced Time Intelligence
  • Advanced Relationship in DAX
  • Hierarchies in DAX
Module 4: Advanced Data Visualization with Power BI

This course is module 4 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about data visualization in Power BI. Day starts with basics of visualizations of basic charts. You will learn best practices and considerations for coloring, choosing the right visual, numeric visualization and many other tips through the course. You will learn about custom visuals, how to build custom visuals. all tips and tricks in visualizations including filters, slicers, drill down/up, best practices of map visualizations and many other real-world examples with hands on lab and lecture. You will leave this course with a Jedi level of visualization.

Agenda;

4.1: Visualization Basics
  • Basic Charts
  • %Mate_Keyword%
  • Clustered vs Stacked
  • Quick Calcs in Power BI
  • Interaction of Visuals
  • Pages
4.2: Visualization Best Practices
  • Pie Chart; Be Careful
  • Coloring
  • Show me the Numbers
  • Which Chart is the Best?
  • Story Telling
  • Combining Visuals
4.3: Slicing and Dicing
  • Filters
  • Slicers
  • Filtering Slicers
  • Drill Down/Up
4.4: Custom Formatting Visuals
  • Labels
  • Legend
  • Color
  • Extended visualization formatting
  • Group / bin
4.5: Special Visuals
  • Waterfall Chart; Cashflow
  • Scatter Chart; Story Telling
  • Line Chart; Powerful
  • Table and Matrix with Conditional Formatting
  • R Visualization
4.6: Map Visualization
  • Default map visual
  • Filled Map; Good, bad, and the ugly
  • Shape Map
  • Custom Map Visuals
  • ArcGIS
4.7: Custom Visuals
  • Using Custom Visuals
  • SynopticPanel by SQLBI
  • Chicklet Slicer
  • 3D Map with GlobeMap Visual
  • Sunburst
  • Time Slicers
4.8: KPIs in Power BI
  • KPI Default visual
  • Dial Gauge
  • Linear Gauge
  • Bullet Chart
4.9: Building a Custom Visual
  • Basics of scripting language
  • Writing first simple custom visual
  • Components of a custom visual component
Module 5: Power BI Service, Gateways, and Architecture

This course is module 5 of the Power BI from Rookie to Rock Star course.

In this course, you will learn everything about Power BI Service. Difference of dashboard and Report. Setting up a gateway. Difference of personal and on-premises gateway. You will learn all tips and tricks of configuration and installation and performance of gateway to connect Power BI on cloud report to on-premises data source and schedule it to refresh. You will also learn about DirectQuery and LiveQuery and difference between these two method. You will learn about architecting a solution with Power BI considering integration options of Power BI with other applications. You will also learn all tips about sharing and security with best practices. This course will be delivered in lecture style plus hands on lab experiments.

Agenda;

5.1: Gateways
  • What is Gateway?
  • Two types of Gateway
  • Personal Gateway; an example
  • On-premises Gateway; not only for Power BI
5.2: On-premises Gateway in Details
  • Requirements for on-premises gateway
  • Architecture Flow diagram of the gateway
  • Installation and Configuration considerations
  • Install and Configure Gateway example
  • Data Source Definition in Power BI Service
  • Schedule Refresh
5.3: Gateway Performance
  • Performance Considerations
  • Limitations of Gateway
  • Gateway for SSAS Live data source
5.4: DirectQuery
  • Step beyond 1/10GB Limitation in Power BI
  • Limitations of DirectQuery
  • Dashboard and Report considerations for DirectQuery
  • Performance Considerations
5.5: Live Query
  • Using SSAS Live data source
  • Difference of DirectQuery and Live Query
  • Enterprise Scale architecture
  • UPN Mapping
  • Architecture of Gateway and SSAS Live Connection
5.6: Power BI Service
  • Dashboard vs Report
  • Dashboard Tiles
  • Data Classification
  • Power Q&A
  • Tips and Tricks for Power Q&A
5.7: Sharing
  • Dashboard Sharing
  • Work Groups in Power BI
  • Content Packs
  • Publish to Web
  • Comparison of all Sharing methods
  • Sharing Architecture for enterprise
5.8: Administration
  • Admin Portal
  • Set Power BI Administrator
  • Tenant Settings
  • Audit Log
5.9: Row Level Security
  • Row Level Security in Power BI; regardless of Data Source
  • %Mate_Description%
  • Row Level Security in SSAS Live Connection
  • Dynamic Row Level Security
5.10: Integration
  • Analyze in Excel
  • Power BI Publisher for Excel
  • Reporting Services and Power BI
  • Power BI and Power Point
5.11: Real-time
  • REST API of Power BI
  • Real-time Tiles
  • Azure Stream Analytics
5.12: Architecture
  • Architecture for Enterprise Scale
  • Architecture for Reporting
  • Architecture for Self-Service
  • Licensing
  • Power BI Free
  • Power BI Pro
  • Power BI Premium
Why Power BI Training?

Power BI is the newest Microsoft BI tool for data mash up, build modelling, and visualize it effectively. It supports mobile devices, it support self-service, and along with its great functionalities, it doesn’t require heavy development or production system.

Common Myths about Power BI

There are some myths about Power BI that sometimes prevents people and organization to move towards using this product. We’ve listed some of myths in following. Please note that these are Myths, and they are not right assumptions.

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

There are many scenarios that Power BI has been used in enterprise solutions. Power BI features for data mash up (with the very powerful data transformation component: Power Query), and data modelling  based on xVelocity in-memory engine (Power Pivot), and great data visualization components such as Power View and Power Map, along with mobility support of this product, are rarely available in other products. We have designed, implemented and have seem many BI enterprise solutions based on Power BI within very large organizations.

Myth 2: Power BI is easy to use, and doesn’t require training course.

Power BI is an easy to use tool, but for basic functions. Every BI application requires calculated measure, which needs to be written in DAX. Every BI application requires advanced data transformations which need to be handled with Power Query M scripting language. Designing and implementing solutions with Best Practices is always a requirement for reliable BI applications. We designed our Power BI training in a way that delivers advanced content for all components of Power BI, and fortify your team’s knowledge on the product, so they can solve any complex challenge with this tool.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Power Query is the core of data extraction in Power BI. Power Query supports wide range of data sources. Not only SQL Server, but also Oracle, MySQL, web service result set, DB2 and many other data source are supported. There is also possibility to connect to many systems such as salesforce. The Visualization component of Power BI is also HTML5 supported, and is available for all mobile devices. Power BI app in AppStore, and Google PlayStore as well as Microsoft AppStore enables dashboards and data visualizations to be available in all environments.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In fact the reverse is true. Power BI is such powerful that can be replacement of many other expensive BI tools in the market. We’ve been through scenarios of successful Power BI solutions that have been replacement of Cognos, IBM products, Oracle WB, SAP BO, and so on. Power BI has 5 powerful components that cover main aspects of BI and data analysis system.

In addition there are always possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

Instructor: Reza Rad

Our trainer is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI book from Rookie to Rock Star.

In-Person Training;

Our Power BI in person training will be held in high quality hotels with recommendation for hotel bookings for attendees. There will be special group rating fee as well as early bird and past attendees discount. for schedule of our in person training follow this link:

Online Training;

We run online training with GoToWebinar and GoToTraining applications. These applications provide highly reliable communication channel between instructor and attendees. For schedule of our online training follow this link:

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

Schedule of Power BI Trainings in 2017 What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

Who Attended RADACAD Training Courses

 

Time

16 (Monday) - 20 (Friday)

Organizer

Reza Radreza@radacad.com

Learn More
Online
16jul - 20jul 169:00 amjul 20Advanced Analytics and Machine Learning – US West July 2018
Event Details

 

more

Event Details
Register Here
Advanced Analytics – Live Instructor Led 5-days Course

Time in your area

Start: Monday, July 16, 2018
End: Friday, July 20, 2018
Time: 9:00am – 4:30 pm ADT

Suitable time for these cities:
Acapulco, Adak, Adamstown, Aguascalientes, Albuquerque, Alert, Alofi, Anchorage, Asuncion, Atlanta, Augusta, Austin, Baker Lake, Baltimore, Basse-Terre (Guadeloupe), Basseterre (St. Kitts), Belém, Belmopan, Billings, Bismarck, Blanc-Sablon, Bogota, Boise, Boston, Bridgetown, Buenos Aires, Calgary, Cancún, Caracas, Castries, Cayenne, Charleston, Cheyenne, Chibougamau, Chicago, Columbia, Columbus, Concord, Coral Harbour, Córdoba, Dallas, Denver, Des Moines, Detroit, Dover, Easter Island, Edmonton, Eureka, Fairbanks, Fort-de-France, Fortaleza, Galapagos Islands, George Town (Cayman), Georgetown (Guyana), Grise Fiord, Guadalajara, Guatemala City, Guayaquil, Halifax, Hamilton, Happy Valley-Goose Bay, Hartford, Havana, Hermosillo, Honolulu, Houston, Indianapolis, Inuvik, Jackson, Juneau, Kansas City, Kingston, Kingstown, Knoxville, Kuujjuaq, La Paz, Las Vegas, Lima, Lincoln, Little Rock, Los Angeles, Louisville, Madison, Managua, Manaus, Mazatlan, Mexicali, Mexico City, Miami, Midland, Midway, Milwaukee, Minneapolis, Montevideo, Montgomery, Montpelier, Montreal, Nashville, Nassau, New Orleans, New York, Newark, Oklahoma City, Orlando, Ottawa, Panama, Papeete, Paramaribo, Pensacola, Philadelphia, Phoenix, Pond Inlet, Port-au-Prince, Port of Spain, Portland, Providence, Punta Arenas, Québec, Quito, Raleigh, Rapid City, Rarotonga, Recife, Regina, Resolute Bay, Richmond, Rio Branco, Roseau, Sacramento, Saint George’s, Saint John (CA – NB), Saint John’s (Antigua), Salem, Salt Lake City, Salvador, San Diego, San Francisco, San Jose (CR), San Jose (USA), San Juan, San Salvador, Santiago, Santo Domingo, Seattle, Sioux Falls, St. Louis, St. Paul, Stanley, Sucre, Tegucigalpa, Thule Air Base, Tijuana, Topeka, Toronto, Unalaska, Vancouver, Veracruz, Washington DC, Whitehorse, Winnipeg, Yellowknife

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

This training is three days of training using Machine Learning and R with SQL Server, Power BI, and concepts of Machine Learning.

Product Description Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Length: 5 days Prerequisite: This course is a beginner to advanced level course. You don’t need any prerequisites for attending in this course. Instructor: Dr. Leila Etaati

 

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

At this training, you will learn:

Day 1: Azure ML, R Basics

In the first day, you will be familiar with the basic concepts of Machine Learning in Azure ML and some basic concepts of R in R Studio and Microsoft Visual studio 2015. In Day 1 you will learn;

Azure ML:

  • The main functionality of Azure ML and how to set it up.
    • Login in Azure ML, create experiment in Azure ML
  • Different components in Azure environments
    • Data import and Export into Azure studio in “Dataset” component using “Import Data”, “Export Data”, “Enter Data Manually”.
    • Using “Reader” component to fetch data from cloud services
    • Data format conversion such as “Convert to CSV”, “Convert to Dataset”
    • Data Transformation learning with counts” Creates a transformation that turns count tables into features, so that you can apply the transformation to multiple datasets.
    • Manipulation: Add columns and rows, Apply SQL Transformation, Clean Missing Data, Join Data, Remove Duplicate Row, Select Column in Dataset.
    • Split and Sample: Partition and Sample and Split Data.
    • Scale and reduce: Group Data in Bins and Normalize Data.
    • Feature Selection: for predictive analytics
    • Write R scripts in Azure ML using” Execute R”
    • Using “Time series Anomaly Detection” Component to detect anomalies in the input time series data.
  • How to work with different algorithms in Azure ML and how to use them for predictive, descriptive and prescriptive analysis, such as
    • Classifications algorithms such as “Multiclass Decision Forest”,” Multiclass Neural Network”, “Two-class Boosted Decision Tree”.
    • Clustering k-means Clustering
    • Regression algorithms: Linear Regression, Bayesian Linear Regression.
  • How to evaluate created model and analysis the evaluation output using evaluate model component. And how to enhance the model accuracy via cross validation and feature selection
  • How to create a API from Created model and how to call the created API in Excel.
  • Suggestions for possible architecture when using Azure ML.
  • Practice to create a simple ML Experiment in Azure ML.

R:

  • The basic of R language.
  • Installing R studio, setting up R server in SQL Server, setting up R in power BI,
  • Main data structure in R such as Data frame, Vector and List.
  • Exploring and Understanding Data in R
    • Exploring numeric variable, categorical variable and relationship between variables, using summary and STR function
    • How to use some of the main packages in R such as ggplot2 to visualize data.
    • Creating a ggplot, Aesthetic mappings, Facets, Geometric objects, Statistical transformations, Position adjustments, Coordinate systems,
  • Data Transformation with dplyer
    • Functions like filter()  for Comparisons, Logical operators, Missing values. Or function “select”
  • sqldf to use SQL Statements for query dataset, RODBC for fetching data from SQL database
  • The main concepts of basic statistics and how they can be helpful like: mean, median, standard division, and so forth will be discussed.
  • Practice in R and using some packages

 

Day 2: R algorithms and Power BI

The main aim of days 2 is to learn some of main machine learning algorithms, and understand how they work and how they can solve different type of real life problems. You will familiar with these algorithms and their syntax in R, and how to use them in Power BI. Moreover, you will learn how to embed some R visualization in Power BI.

In day 2 you will learn;

  • How classification algorithm like KNN works. and its relevant code in R.
    • KNN concepts
    • Write the KNN in R code
    • How to evaluate the result
    • How to improve the result by changing related parameters
  • Decision Tree concepts and its relevant R codes
    • What is decision tree, the concepts and how it works
    • Introduce different type of decision tree algorithms that are more common.
    • Introduce Rpart packages, how to write the related R code in Rstudio and Rvisual studio
    • See the Rpart package in Power BI visual
    • Package C50 for decision tree how to evaluate result and how to improve the model
  • Associative Rules
    • Audience will learn the main concepts behid the Associative rules
    • Where to use it and how it brings insight for users
    •  They will learn to write the code in R
    • Become familiar with concepts such as support, confidence and Lift.
    • Learn how Apriori packages and algorithm works
    • How to evaluate the association rules result
    • How to display it in Power BI
    • How to improve the results
  • How to write R codes in Power BI for transformation, and also creating new queries
    • How to set up the R in Power BI
    • How to write Simple R code for correlation analysis in R
    • How to create R visuals in Power BI
    • Do data transformation in Power BI with R functions
    • How to create interactive R reports in Power BI
    • How to call azure ML API into Power BI
      • Shows how to create functions in Power BI to call the API from Azure ML
    • Create a prediction model in Power BI and show the result in visualization.

Day 3: R algorithms and SQL Server 2016

In third day, you will learn how to bring analytics and intelligence using SQL server 2016.  Moreover, you will also learn some other important machine learning algorithms.

In Day 3 you will learn:

  • Neural Network algorithm
    • The concepts behind it and how it works
    • The ksvm() function
    • Evaluate the model and how to improve the performance
  • Time series algorithm
    • Time series concept difference between seasonality and trend
    • The function that is used to create the time series model
    • How to improve and evaluate it
  • Regression algorithm
    • Concept behind the regression
    • Predict numeric data (e.g. using linear regression) the function used to do the linear regression
    • How to create a model that support the nonlinear models
    • Multiple regression, logistic regression and so forth
    • How to evaluate the results
  • Recommendation (content-based filtering and collaborative filtering).
    • What is recommendation and what is content filtering and collaborating filtering
    • How to implement content filtering and collaborative filtering
    • Using classification and clustering algorithms to create a recommendation system
    • Azure ML recommendation model

Moreover, you will learn how to use machine learning in SQL Server 2016 and in SSRS.

    • Set up SQL Server to run the R scripts
    • The best practice for implementing a prediction process in SQL Server 2016
    • Create a correlation analysis in SQL Server
    • Create a decision tree diagram in SSRS via writing code in R
    • See an end to end predictive analysis code from getting data, create models, evaluate models and publish the result.
    • Practice: creating a predictive solution in SQL Server 2016

 

This course is full of hands on labs, and you will experiment all examples through real-world demos. At the end of the 3-day training course, you will be able to use techniques and concepts of this training in your Analytics challenges.

Instructor: Dr. Leila Etaati

Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

 

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualisations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Registration:

http://learn.radacad.com/product/advanced-analytics-live-instructor-led-3-days-course/

More Details:

http://radacad.com/advanced-analytics-training

Time

16 (Monday) 9:00 am - 20 (Friday) 4:30 pm

Learn More
Singapore TBD
13aug - 17aug 139:00 amaug 17Advanced Analytics and Machine Learning - Singapore August 2018
Event Details

more

Event Details
Register Here
Advanced Analytics – in-person Instructor Led 5-days Course
Start: Monday, August 13, 2018
End: Friday, August 17, 2018
Time: 9:00am – 4:30 pm

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

This training is 5 days of training using Machine Learning and R with SQL Server, Power BI, and concepts of Machine Learning.

Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Length: 5 days Prerequisite: This course is a beginner to advanced level course. You don’t need any prerequisites for attending in this course. Instructor: Dr. Leila Etaati

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

In 5 days course, you will learn how to do machine learning in cloud using Azure ML, learn about basics of R, how to use R inside Power BI and R in SQL Server 2016:

Azure ML Studio and Azure ML Workbench (1.5 day )

The basics of Machine Learning

Some basics concepts will be explained like Process of machine learning,

What is descriptive, predictive and prescriptive, what is Cortana and how Azure ML can be used

Import data: The main component for importing data from local PC, how to import data from other work space, how to import data from html website, how to import data from cloud such as Azure SQL DB.

Data Cleaning: data cleaning is the main process that we should done before any machine learning process. I will explain the available component in Azure ML. Cleaning missing value, remove duplicate data, select column, clip value (remove outliers), group data into bins, create indicator for data, how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.

4- Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using sampling approach, how to create different folds for aim of cross validation.

5- Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example on prediction a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented, different algorithms will apply for a problem. the main concepts of k-mean , how to use elbow chart to identify the number of cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content based filtering  and hybrid approach for recommendation will be discussed.

5- Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross validation, how to do cross validation to apply a model to different folds of data, how to check the different values for an each parameters and see the related accuracy to that.

6-Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be show. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate model, enter data manually component and add row component.

7-Publish to Web:  the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.

8-Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to csv and other formats will be shown.

9-Using Azure ML Workbench for deploying the models for Data wrangling and data visualization

10- Model and experiment Managment in cortana

11- A brife explanation on Python

Introduction to R (0.5 days)

The basics of R will be shown in class

R basics:  the basics of R and data structure, like vector, list, data frame and factor will be discussed. The R studio environment will be shown how to write the R code, what is packages, how we can import data set into R using RStudio environment, how to import data from SQL Server, how to write SQL statement for data wrangling inside R studio,

Statistics: some of the main statistics computation will be explained, str, summary command, what is mean, median, first quarter, third quarter, standard deviation, and so on, how to show them using boxplot, and normal distribution. How to analysis data via these simple statistics.

Packages: how to install packages by writing code and without writing code, how to manage the packages, how to use dplyr package for data cleaning and wrangling, how to use ggplot2 package to draw pictures. Introduce some of the packages for drawing maps like leaflet and so on.

R and Power BI for Visualization and Machine Learning (2.5 days)

In this session, I will talk how to empower BI using R. this has four main section from how to draw R visual that we do not have normally in Power BI, how to create a R custom Visual for better usage and sharing with other, how to do machine learning and do different algorithms inside Power BI and finally how to use the available custom visual in office store.

Draw R visual in Power BI: in this session, I will show how to set up power BI to use R, how to create R visual inside power bi, how to debug and run code there, how to avoid some usual mistake to get better visualization. Some of the visual from ggplot2 package will be introduced. The Facet chart to show 5 different variables in a chart, how to show different types of chart in facet chart, how to create slope chart just to show the difference of a variable in two dimension (e.g. two time). How to draw a column width chart to show a bar chart with different weight, how to draw polar chart from our bar charts in different ways, how to draw a correlation chart for correlation analysis, how to draw a calendar chart, how to draw a map chart with desire sub chart in it and so on.

Create a Custom Visual chart:  the main process of how to create a custom R visual will be explained. From installing desired component to writ e the code in command prompt to create a template. How to change the r files, how to change the name of chart using json files, how to create pbiviz file so you able to import it into power bi. Moreover, the plotly package will be shown and how it makes the visual more interactive than before.

Machine Learning Algorithms with R and Power BI: in this part I am going to show how to do machine learning inside Power BI with a brief explanation on different algorithms.

I will show how to do machine learning inside power query using R transformation component, how to write R scripts to create some functions inside Power Query for more data transformation. Moreover the brief description of some algorithms with their R codes and required packages in R will be discussed.

K-Nearest neighbour: the main concepts for using KNN, how it works the statistic behind it, how to enhance and improve it, how to write the relevant code inside Power BI. Moreover, a discussion on overfitting and under fitting will be done. And how identify the best K value can help us in KNN algorithm.

Clustering with k-mean: what is the k-mean already discuss in first day. How to identify the number of cluster using elbow chart. How to analysis a clustering problem in power bi using power BI visuals.

Decision tree: the concepts behind it, how to specify the best value for decision tree depth and other parameters. How decision tree can be good for predicting a group, predict a value and also do the feature selection. How to draw a decision tree inside power bi and how to use it just for prediction.

Neural Network: the main concepts behind the neural network, the different structure for neural network, how to identify the best number of the hidden node, how to do prediction a group and a value using NN. How to show a NN structure in power bi.

Regression: the concepts behind the regression and some simple statistics will be provided. How to use if for predicting a value and how to evaluate the result of a regression will be shown. The liner and none linear regression also will be discussed

Market Basket Analysis: the main concepts for market basket analysis, the concepts of supports, confidence and lift will be shown, and how to show it in power bi will be discussed.

Time series: a detail concepts for time series will be presented. From simple time series without trend and seasonality and stationary one with no correlation between residual to Arima model with trend and seasonality (almost 6 different mode) will be discussed. The composite chart the exponential smoothing approach, the ACF and PCAF chart to identify the autocorrelation will be shown. Also, audience will learn how to draw a relevant time series chart using R codes in Power BI.

The optimization problem: a very brief introduction into optimization problem will be done, people will be familiar with linear programming. How to do it in Excel using Solver and how to do it in R and Power BI.

 

Power BI Office Store visual:   in this part, I will show some of existing power BI custom R visual that Microsoft provided them in Office store such as decision tree charts, accusative rules charts, clustering, time series for Arima model, Time series for exponential smoothing, decompose time series and so on. I will show how to setup the parameters and how to use them.

 

Using R services and ML services in SQL Server and Azure Data Lake(0.5 day)

How to set up: There is a possibility to do machine learning inside SQL Server 2016 using R codes. In half day audience, will be familiar how to set their SQL Server to access the R server for doing the machine learning. They learn how to call a store procedure for using an external code like R.  moreover, they learn how to use external scripts for doing machine learning writing R codes inside SQL Server, how to pass the data to R and how to get the output.

Best practice and Examples: Audience will learn the best practice for doing machine earning inside the SQL Server, create separate store procedures. A customer churn example will be shown. This example is for prediction.

Evolutionary Package: there is a package that most of Microsoft algorithms are there. I will show how to use these algorithms and what algorithms are exist in this package.

Draw R charts in SSRS: I will show how to create a R chart inside SQL Server Management studio and store it as binary value in a table. Finally, how to show it in SSRS.

 Azure Data Lake: I will show how to write R scripts inside Azure Data Lake and also how to explor the Azure data lake file inside RStudio

 

This course is full of hands on labs, and you will experiment all examples through real-world demos. At the end of the 3-day training course, you will be able to use techniques and concepts of this training in your Analytics challenges.

Instructor: Dr. Leila Etaati

Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

 

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

 

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Registration:

http://learn.radacad.com/product/advanced-analytics-live-instructor-led-3-days-course/

More Details:

http://radacad.com/advanced-analytics-training

Time

13 (Monday) 9:00 am - 17 (Friday) 4:30 pm CEST

Location

Singapore

TBD

Learn More
Singapore TBD
13aug - 17aug 139:00 amaug 17Power BI from Rookie to Rock Star - Singapore August 2018
Event Details

Register Here What

more

Event Details
Register Here

What others say about the training and trainer;

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, United States

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

 

Course Details

This is the most comprehensive course for Power BI which split in daily modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are list and detailed agenda of each module:

  • Module 1: Power BI Essentials  – Day 1
  • Module 2: Advanced Power Query and Data Transformation – Day 2
  • Module 3: Advanced Data Modeling in Power BI with DAX – Day 3
  • Module 4: Advanced Data Visualization in Power BI – Day 4
  • Module 5: Advanced Gateways, Power BI Service, Administration, and Architecture – Day 5

 

Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

 

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.
FRYE Női Melissa Button rövid bokacsizma Jég mosott antik húzni bőr-77908 , UGG Kid s Bailey Bow Starlight Boot haditengerészet , Sebago női Harper Kiltie Tie Ballet Flat Navy Nubuck Propet férfi M3910 Vista Walker Oxford Fekete Smooth , NAOT Női Harore Flat Bronz ragyogó, barna csillogó, vulkanikus barna , Crocs Unisex Classic Clog Fekete Columbia női Redmond túracipő Cápa, Vihar A North Face Womens Storm III Mid vízálló Sötét gull szürke és sifon sárga , Sam Edelman női Elisa sík szandál Tintasugaras Skechers BOBS a női boboktól Plüss-béke és szerelem fehér Kate Spade New York Női Noreen Ballet Flat Természetes , Eastland Women s Buck Taupe Suede , Spira Női Taos Oxford-Inspired Sneaker Fekete LifeStride Női I-Loyal Flat Sötétszürke 2 Birkenstock Roma Sandal (kisgyerek / kislány / nagy kölyök) Mocca Aquatalia által Marvin K. Női Stella Mule Fekete , OLUKAI Nohea Mesh Shoe - Férfiak Mustang / Lime Peel , Klogs USA Női DUSTY Clog papaya , Hush kölyökkutyák női kaktusz balett Meztelen Walking Cradles Női Hartford Flat Sandal Fekete nubuk , Qupid női Milia-152 Fashion Boot Kék , Loeffler Randall Női Nellie (Tumbled Leather) Fekete , Kate Spade New York Női Raquel Fashion Boot Fekete , Alegria Womens Eryn Wedge Slip-On Gesztenye csillám Coach Womens Jemma Fekete bőr Baffin Női Csizma Rain Boot Fekete , DAWGS Mossy Oak női 13 hüvelykes ausztrál stílusú csizma Kacsa Vak , BEARPAW női morgan csizma, kék zászló, gumi, gyapjú, 11 M - , Reebok RB4721 Férfi Beviad biztonsági cipő - sötétszürke Kék Easy Street női boldog sarkú szandál haditengerészet

 

1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

 

 

1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

 

1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced

 

1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization

 

1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways

 

1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh

 

Module 2: Advanced Power Query and Data Transformation in Power BI

This course is module 2 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Agenda;

2.1: Get Data
  • Different Data Sources
  • What is Power Query?
  • Power Query in Excel and Power BI
  • Basic Transformations
  • Get Data from Web
2.2: Query Editor
  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from SQL Server
  • Get Data from CSV Files
  • Get Data from Excel
  • Get Data from JSON
  • Transformation Pane
2.3: Power Query Syntax
  • Data Types in Power Query
  • Query Properties
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
2.4: Combine Queries
  • Merge, Joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder
2.5: Transformations
  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Add as new query / Drill Down
2.6: Table Transformations
  • Group By
  • Extending Group By with Expression Editor
  • Transpose
  • Pivot, Unpivot
2.7: Text Transformations
  • Split
  • Merge (Concatenate)
  • Parse
  • Extract
2.8: Numeric Transformations
  • Standard
  • Scientific
  • Statistics
2.9: More Transformations
  • Date Transformations (Year, Month, Quarter)
  • Extending Fiscal Date Column
  • Time Transformations
  • Adding Time/Date banding
  • Structured Column
  • Expand
  • Aggregate
  • Add Custom Column
2.10: Power Query Formula Language: M
  • What is M? and the importance of learning M
  • M Syntax
  • Things to Consider for M Scripting
  • Basic examples of M
  • Values in M
  • Logical Operations
2.11: Advanced M Scripting
  • #Shared Keyword; function library of Power Query
  • Parameters
  • Custom Functions
  • Error Handling in Power Query
  • Generators in Power Query: Implementing Loop Structure
  • EACH singleton function
2.12: Use Cases
  • Date Dimension with Power Query
  • Day Number of Year Custom Function
  • Looping through files in a folder with Power Query
  • Online Date Time Scheduler with Power Query

 

Module 3: Advanced Power BI Modeling and DAX

This course is module 3 of the Power BI from Rookie to Rock Star course.

In this course, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Agenda;

3.1: Power BI Modeling 101
  • Relationship in Power BI
  • Relationship based on multiple Columns
  • Role Playing Dimension
  • Formatting
  • Hide/Unhide
  • Hierarchy
  • Basic Calculated Column and Measure
  • Sort by Column
3.2: Introduction to DAX
  • Syntax of DAX
  • Naming in DAX
  • Logical Operations
  • Data Types in Power BI Model
  • Overview of Functions
  • Variables
3.3: Functions in DAX in Details
  • Text Functions
  • Information Functions
  • Logical Functions
  • Date and Time Functions
  • Aggregation Functions
3.4: Filter, Value, and Relationship Functions
  • ALL
  • Examples of using ALL function
  • Filter Function
  • Related
  • RelatedTable
3.5: Evaluation Contexts
  • Row Context
  • Filter Context
  • Exception for Row Context
  • Exception for Filter Context
  • Calculate Function
3.6: Time Intelligence Functions
  • Year to Date, Quarter to Date
  • Fiscal Year to Date
  • Same Period Last Year
  • Running Total
  • Rolling 12 Month Sales
  • Average 12 Month Sales
  • Rolling 6 Months
  • Flexible banding
3.7: Calculated Tables
  • Role Playing Dimension
  • Top 10 Customers
  • More Scenarios of Using Calculated Tables
  • Performance Consideration
3.8: Best Practices Tips and Tricks
  • Solving DAX Now and Today Time zone Issue
  • Modeling Best Practices
  • Advanced Time Intelligence
  • Advanced Relationship in DAX
  • Hierarchies in DAX

 

Module 4: Advanced Data Visualization with Power BI

This course is module 4 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about data visualization in Power BI. Day starts with basics of visualizations of basic charts. You will learn best practices and considerations for coloring, choosing the right visual, numeric visualization and many other tips through the course. You will learn about custom visuals, how to build custom visuals. all tips and tricks in visualizations including filters, slicers, drill down/up, best practices of map visualizations and many other real-world examples with hands on lab and lecture. You will leave this course with a Jedi level of visualization.

Agenda;

4.1: Visualization Basics
  • Basic Charts
  • Clustered vs Stacked
  • Quick Calcs in Power BI
  • Interaction of Visuals
  • Pages
4.2: Visualization Best Practices
  • Pie Chart; Be Careful
  • Coloring
  • Show me the Numbers
  • Which Chart is the Best?
  • Story Telling
  • Combining Visuals
4.3: Slicing and Dicing
  • Filters
  • Slicers
  • Filtering Slicers
  • Drill Down/Up
4.4: Custom Formatting Visuals
  • Labels
  • Legend
  • Color
  • Extended visualization formatting
  • Group / bin
4.5: Special Visuals
  • Waterfall Chart; Cashflow
  • Scatter Chart; Story Telling
  • Line Chart; Powerful
  • Table and Matrix with Conditional Formatting
  • R Visualization
4.6: Map Visualization
  • Default map visual
  • Filled Map; Good, bad, and the ugly
  • Shape Map
  • Custom Map Visuals
  • ArcGIS
4.7: Custom Visuals
  • Using Custom Visuals
  • SynopticPanel by SQLBI
  • Chicklet Slicer
  • 3D Map with GlobeMap Visual
  • Sunburst
  • Time Slicers
4.8: KPIs in Power BI
  • KPI Default visual
  • Dial Gauge
  • Linear Gauge
  • Bullet Chart
4.9: Building a Custom Visual
  • Basics of scripting language
  • Writing first simple custom visual
  • Components of a custom visual component

 

 

 

Module 5: Power BI Service, Gateways, and Architecture

This course is module 5 of the Power BI from Rookie to Rock Star course.

In this course, you will learn everything about Power BI Service. Difference of dashboard and Report. Setting up a gateway. Difference of personal and on-premises gateway. You will learn all tips and tricks of configuration and installation and performance of gateway to connect Power BI on cloud report to on-premises data source and schedule it to refresh. You will also learn about DirectQuery and LiveQuery and difference between these two method. You will learn about architecting a solution with Power BI considering integration options of Power BI with other applications. You will also learn all tips about sharing and security with best practices. This course will be delivered in lecture style plus hands on lab experiments.

Agenda;

5.1: Gateways
  • What is Gateway?
  • Two types of Gateway
  • Personal Gateway; an example
  • On-premises Gateway; not only for Power BI
5.2: On-premises Gateway in Details
  • Requirements for on-premises gateway
  • Architecture Flow diagram of the gateway
  • Installation and Configuration considerations
  • Install and Configure Gateway example
  • Data Source Definition in Power BI Service
  • Schedule Refresh
5.3: Gateway Performance
  • Performance Considerations
  • Limitations of Gateway
  • Gateway for SSAS Live data source
5.4: DirectQuery
  • Step beyond 1/10GB Limitation in Power BI
  • Limitations of DirectQuery
  • Dashboard and Report considerations for DirectQuery
  • Performance Considerations
5.5: Live Query
  • Using SSAS Live data source
  • Difference of DirectQuery and Live Query
  • Enterprise Scale architecture
  • UPN Mapping
  • Architecture of Gateway and SSAS Live Connection
5.6: Power BI Service
  • Dashboard vs Report
  • Dashboard Tiles
  • Data Classification
  • Power Q&A
  • Tips and Tricks for Power Q&A
5.7: Sharing
  • Dashboard Sharing
  • Work Groups in Power BI
  • Content Packs
  • Publish to Web
  • Comparison of all Sharing methods
  • Sharing Architecture for enterprise
5.8: Administration
  • Admin Portal
  • Set Power BI Administrator
  • Tenant Settings
  • Audit Log
5.9: Row Level Security
  • Row Level Security in Power BI; regardless of Data Source
  • Row Level Security in SSAS Live Connection
  • Dynamic Row Level Security
5.10: Integration
  • Analyze in Excel
  • Power BI Publisher for Excel
  • Reporting Services and Power BI
  • Power BI and Power Point
5.11: Real-time
  • REST API of Power BI
  • Real-time Tiles
  • Azure Stream Analytics
5.12: Architecture
  • Architecture for Enterprise Scale
  • Architecture for Reporting
  • Architecture for Self-Service
  • Licensing

 

Instructor: Reza Rad

Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, PASS BA Conference, SQLBits, TechEds, Ignites, and many other conferences.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star

 

 

What others say about the training and trainer

 

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

Time

13 (Monday) 9:00 am - 17 (Friday) 4:30 pm

Organizer

Reza Radreza@radacad.com

Learn More
Perth
20aug - 24aug 209:00 amaug 24Advanced Analytics and Machine Learning - Perth August 2018
Event Details

more

Event Details
Register Here
Advanced Analytics – in-person Instructor Led 5-days Course
Start: Monday, August 20, 2018
End: Friday, August 24, 2018
Time: 9:00am – 4:30 pm

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

This training is 5 days of training using Machine Learning and R with SQL Server, Power BI, and concepts of Machine Learning.

Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Length: 5 days Prerequisite: This course is a beginner to advanced level course. You don’t need any prerequisites for attending in this course. Instructor: Dr. Leila Etaati

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

In 5 days course, you will learn how to do machine learning in cloud using Azure ML, learn about basics of R, how to use R inside Power BI and R in SQL Server 2016:

Azure ML Studio and Azure ML Workbench (1.5 day )

The basics of Machine Learning

Some basics concepts will be explained like Process of machine learning,

What is descriptive, predictive and prescriptive, what is Cortana and how Azure ML can be used

Import data: The main component for importing data from local PC, how to import data from other work space, how to import data from html website, how to import data from cloud such as Azure SQL DB.

Data Cleaning: data cleaning is the main process that we should done before any machine learning process. I will explain the available component in Azure ML. Cleaning missing value, remove duplicate data, select column, clip value (remove outliers), group data into bins, create indicator for data, how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.

4- Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using sampling approach, how to create different folds for aim of cross validation.

5- Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example on prediction a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented, different algorithms will apply for a problem. the main concepts of k-mean , how to use elbow chart to identify the number of cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content based filtering  and hybrid approach for recommendation will be discussed.

5- Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross validation, how to do cross validation to apply a model to different folds of data, how to check the different values for an each parameters and see the related accuracy to that.

6-Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be show. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate model, enter data manually component and add row component.

7-Publish to Web:  the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.

8-Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to csv and other formats will be shown.

9-Using Azure ML Workbench for deploying the models for Data wrangling and data visualization

10- Model and experiment Managment in cortana

11- A brife explanation on Python

Introduction to R (0.5 days)

The basics of R will be shown in class

R basics:  the basics of R and data structure, like vector, list, data frame and factor will be discussed. The R studio environment will be shown how to write the R code, what is packages, how we can import data set into R using RStudio environment, how to import data from SQL Server, how to write SQL statement for data wrangling inside R studio,

Statistics: some of the main statistics computation will be explained, str, summary command, what is mean, median, first quarter, third quarter, standard deviation, and so on, how to show them using boxplot, and normal distribution. How to analysis data via these simple statistics.

Packages: how to install packages by writing code and without writing code, how to manage the packages, how to use dplyr package for data cleaning and wrangling, how to use ggplot2 package to draw pictures. Introduce some of the packages for drawing maps like leaflet and so on.

R and Power BI for Visualization and Machine Learning (2.5 days)

In this session, I will talk how to empower BI using R. this has four main section from how to draw R visual that we do not have normally in Power BI, how to create a R custom Visual for better usage and sharing with other, how to do machine learning and do different algorithms inside Power BI and finally how to use the available custom visual in office store.

Draw R visual in Power BI: in this session, I will show how to set up power BI to use R, how to create R visual inside power bi, how to debug and run code there, how to avoid some usual mistake to get better visualization. Some of the visual from ggplot2 package will be introduced. The Facet chart to show 5 different variables in a chart, how to show different types of chart in facet chart, how to create slope chart just to show the difference of a variable in two dimension (e.g. two time). How to draw a column width chart to show a bar chart with different weight, how to draw polar chart from our bar charts in different ways, how to draw a correlation chart for correlation analysis, how to draw a calendar chart, how to draw a map chart with desire sub chart in it and so on.

Create a Custom Visual chart:  the main process of how to create a custom R visual will be explained. From installing desired component to writ e the code in command prompt to create a template. How to change the r files, how to change the name of chart using json files, how to create pbiviz file so you able to import it into power bi. Moreover, the plotly package will be shown and how it makes the visual more interactive than before.

Machine Learning Algorithms with R and Power BI: in this part I am going to show how to do machine learning inside Power BI with a brief explanation on different algorithms.

I will show how to do machine learning inside power query using R transformation component, how to write R scripts to create some functions inside Power Query for more data transformation. Moreover the brief description of some algorithms with their R codes and required packages in R will be discussed.

K-Nearest neighbour: the main concepts for using KNN, how it works the statistic behind it, how to enhance and improve it, how to write the relevant code inside Power BI. Moreover, a discussion on overfitting and under fitting will be done. And how identify the best K value can help us in KNN algorithm.

Clustering with k-mean: what is the k-mean already discuss in first day. How to identify the number of cluster using elbow chart. How to analysis a clustering problem in power bi using power BI visuals.

Decision tree: the concepts behind it, how to specify the best value for decision tree depth and other parameters. How decision tree can be good for predicting a group, predict a value and also do the feature selection. How to draw a decision tree inside power bi and how to use it just for prediction.

Neural Network: the main concepts behind the neural network, the different structure for neural network, how to identify the best number of the hidden node, how to do prediction a group and a value using NN. How to show a NN structure in power bi.

Regression: the concepts behind the regression and some simple statistics will be provided. How to use if for predicting a value and how to evaluate the result of a regression will be shown. The liner and none linear regression also will be discussed

Market Basket Analysis: the main concepts for market basket analysis, the concepts of supports, confidence and lift will be shown, and how to show it in power bi will be discussed.

Time series: a detail concepts for time series will be presented. From simple time series without trend and seasonality and stationary one with no correlation between residual to Arima model with trend and seasonality (almost 6 different mode) will be discussed. The composite chart the exponential smoothing approach, the ACF and PCAF chart to identify the autocorrelation will be shown. Also, audience will learn how to draw a relevant time series chart using R codes in Power BI.

The optimization problem: a very brief introduction into optimization problem will be done, people will be familiar with linear programming. How to do it in Excel using Solver and how to do it in R and Power BI.

 

Power BI Office Store visual:   in this part, I will show some of existing power BI custom R visual that Microsoft provided them in Office store such as decision tree charts, accusative rules charts, clustering, time series for Arima model, Time series for exponential smoothing, decompose time series and so on. I will show how to setup the parameters and how to use them.

 

Using R services and ML services in SQL Server and Azure Data Lake(0.5 day)

How to set up: There is a possibility to do machine learning inside SQL Server 2016 using R codes. In half day audience, will be familiar how to set their SQL Server to access the R server for doing the machine learning. They learn how to call a store procedure for using an external code like R.  moreover, they learn how to use external scripts for doing machine learning writing R codes inside SQL Server, how to pass the data to R and how to get the output.

Best practice and Examples: Audience will learn the best practice for doing machine earning inside the SQL Server, create separate store procedures. A customer churn example will be shown. This example is for prediction.

Evolutionary Package: there is a package that most of Microsoft algorithms are there. I will show how to use these algorithms and what algorithms are exist in this package.

Draw R charts in SSRS: I will show how to create a R chart inside SQL Server Management studio and store it as binary value in a table. Finally, how to show it in SSRS.

 Azure Data Lake: I will show how to write R scripts inside Azure Data Lake and also how to explor the Azure data lake file inside RStudio

 

This course is full of hands on labs, and you will experiment all examples through real-world demos. At the end of the 3-day training course, you will be able to use techniques and concepts of this training in your Analytics challenges.

Instructor: Dr. Leila Etaati

Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

 

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

 

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Registration:

http://learn.radacad.com/product/advanced-analytics-live-instructor-led-3-days-course/

More Details:

http://radacad.com/advanced-analytics-training

Time

20 (Monday) 9:00 am - 24 (Friday) 4:30 pm

Learn More
Perth
20aug - 24aug 209:00 amaug 24Power BI from Rookie to Rock Star - Perth August 2018
Event Details

Register Here What

more

Event Details
Register Here

What others say about the training and trainer;

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, United States

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

 

Course Details

This is the most comprehensive course for Power BI which split in daily modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are list and detailed agenda of each module:

  • Module 1: Power BI Essentials  – Day 1
  • Module 2: Advanced Power Query and Data Transformation – Day 2
  • Module 3: Advanced Data Modeling in Power BI with DAX – Day 3
  • Module 4: Advanced Data Visualization in Power BI – Day 4
  • Module 5: Advanced Gateways, Power BI Service, Administration, and Architecture – Day 5

 

Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

 

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

 

1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

 

 

1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

 

1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced

 

1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization

 

1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways

 

1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh

 

Module 2: Advanced Power Query and Data Transformation in Power BI

This course is module 2 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Agenda;

2.1: Get Data
  • Different Data Sources
  • What is Power Query?
  • Power Query in Excel and Power BI
  • Basic Transformations
  • Get Data from Web
2.2: Query Editor
  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from SQL Server
  • Get Data from CSV Files
  • Get Data from Excel
  • Get Data from JSON
  • Transformation Pane
2.3: Power Query Syntax
  • Data Types in Power Query
  • Query Properties
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
2.4: Combine Queries
  • Merge, Joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder
2.5: Transformations
  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Add as new query / Drill Down
2.6: Table Transformations
  • Group By
  • Extending Group By with Expression Editor
  • Transpose
  • Pivot, Unpivot
2.7: Text Transformations
  • Split
  • Merge (Concatenate)
  • Parse
  • Extract
2.8: Numeric Transformations
  • Standard
  • Scientific
  • Statistics
2.9: More Transformations
  • Date Transformations (Year, Month, Quarter)
  • Extending Fiscal Date Column
  • Time Transformations
  • Adding Time/Date banding
  • Structured Column
  • Expand
  • Aggregate
  • Add Custom Column
2.10: Power Query Formula Language: M
  • What is M? and the importance of learning M
  • M Syntax
  • Things to Consider for M Scripting
  • Basic examples of M
  • Values in M
  • Logical Operations
2.11: Advanced M Scripting
  • #Shared Keyword; function library of Power Query
  • Parameters
  • Custom Functions
  • Error Handling in Power Query
  • Generators in Power Query: Implementing Loop Structure
  • EACH singleton function
2.12: Use Cases
  • Date Dimension with Power Query
  • Day Number of Year Custom Function
  • Looping through files in a folder with Power Query
  • Online Date Time Scheduler with Power Query

 

Module 3: Advanced Power BI Modeling and DAX

This course is module 3 of the Power BI from Rookie to Rock Star course.

In this course, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Agenda;

3.1: Power BI Modeling 101
  • Relationship in Power BI
  • Relationship based on multiple Columns
  • Role Playing Dimension
  • Formatting
  • Hide/Unhide
  • Hierarchy
  • Basic Calculated Column and Measure
  • Sort by Column
3.2: Introduction to DAX
  • Syntax of DAX
  • Naming in DAX
  • Logical Operations
  • Data Types in Power BI Model
  • Overview of Functions
  • Variables
3.3: Functions in DAX in Details
  • Text Functions
  • Information Functions
  • Logical Functions
  • Date and Time Functions
  • Aggregation Functions
3.4: Filter, Value, and Relationship Functions
  • ALL
  • Examples of using ALL function
  • Filter Function
  • Related
  • RelatedTable
3.5: Evaluation Contexts
  • Row Context
  • Filter Context
  • Exception for Row Context
  • Exception for Filter Context
  • Calculate Function
3.6: Time Intelligence Functions
  • Year to Date, Quarter to Date
  • Fiscal Year to Date
  • Same Period Last Year
  • Running Total
  • Rolling 12 Month Sales
  • Average 12 Month Sales
  • Rolling 6 Months
  • Flexible banding
3.7: Calculated Tables
  • Role Playing Dimension
  • Top 10 Customers
  • More Scenarios of Using Calculated Tables
  • Performance Consideration
3.8: Best Practices Tips and Tricks
  • Solving DAX Now and Today Time zone Issue
  • Modeling Best Practices
  • Advanced Time Intelligence
  • Advanced Relationship in DAX
  • Hierarchies in DAX

 

Module 4: Advanced Data Visualization with Power BI

This course is module 4 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about data visualization in Power BI. Day starts with basics of visualizations of basic charts. You will learn best practices and considerations for coloring, choosing the right visual, numeric visualization and many other tips through the course. You will learn about custom visuals, how to build custom visuals. all tips and tricks in visualizations including filters, slicers, drill down/up, best practices of map visualizations and many other real-world examples with hands on lab and lecture. You will leave this course with a Jedi level of visualization.

Agenda;

4.1: Visualization Basics
  • Basic Charts
  • Clustered vs Stacked
  • Quick Calcs in Power BI
  • Interaction of Visuals
  • Pages
4.2: Visualization Best Practices
  • Pie Chart; Be Careful
  • Coloring
  • Show me the Numbers
  • Which Chart is the Best?
  • Story Telling
  • Combining Visuals
4.3: Slicing and Dicing
  • Filters
  • Slicers
  • Filtering Slicers
  • Drill Down/Up
4.4: Custom Formatting Visuals
  • Labels
  • Legend
  • Color
  • Extended visualization formatting
  • Group / bin
4.5: Special Visuals
  • Waterfall Chart; Cashflow
  • Scatter Chart; Story Telling
  • Line Chart; Powerful
  • Table and Matrix with Conditional Formatting
  • R Visualization
4.6: Map Visualization
  • Default map visual
  • Filled Map; Good, bad, and the ugly
  • Shape Map
  • Custom Map Visuals
  • ArcGIS
4.7: Custom Visuals
  • Using Custom Visuals
  • SynopticPanel by SQLBI
  • Chicklet Slicer
  • 3D Map with GlobeMap Visual
  • Sunburst
  • Time Slicers
4.8: KPIs in Power BI
  • KPI Default visual
  • Dial Gauge
  • Linear Gauge
  • Bullet Chart
4.9: Building a Custom Visual
  • Basics of scripting language
  • Writing first simple custom visual
  • Components of a custom visual component

 

 

 

Module 5: Power BI Service, Gateways, and Architecture

This course is module 5 of the Power BI from Rookie to Rock Star course.

In this course, you will learn everything about Power BI Service. Difference of dashboard and Report. Setting up a gateway. Difference of personal and on-premises gateway. You will learn all tips and tricks of configuration and installation and performance of gateway to connect Power BI on cloud report to on-premises data source and schedule it to refresh. You will also learn about DirectQuery and LiveQuery and difference between these two method. You will learn about architecting a solution with Power BI considering integration options of Power BI with other applications. You will also learn all tips about sharing and security with best practices. This course will be delivered in lecture style plus hands on lab experiments.

Agenda;

5.1: Gateways
  • What is Gateway?
  • Two types of Gateway
  • Personal Gateway; an example
  • On-premises Gateway; not only for Power BI
5.2: On-premises Gateway in Details
  • Requirements for on-premises gateway
  • Architecture Flow diagram of the gateway
  • Installation and Configuration considerations
  • Install and Configure Gateway example
  • Data Source Definition in Power BI Service
  • Schedule Refresh
5.3: Gateway Performance
  • Performance Considerations
  • Limitations of Gateway
  • Gateway for SSAS Live data source
5.4: DirectQuery
  • Step beyond 1/10GB Limitation in Power BI
  • Limitations of DirectQuery
  • Dashboard and Report considerations for DirectQuery
  • Performance Considerations
5.5: Live Query
  • Using SSAS Live data source
  • Difference of DirectQuery and Live Query
  • Enterprise Scale architecture
  • UPN Mapping
  • Architecture of Gateway and SSAS Live Connection
5.6: Power BI Service
  • Dashboard vs Report
  • Dashboard Tiles
  • Data Classification
  • Power Q&A
  • Tips and Tricks for Power Q&A
5.7: Sharing
  • Dashboard Sharing
  • Work Groups in Power BI
  • Content Packs
  • Publish to Web
  • Comparison of all Sharing methods
  • Sharing Architecture for enterprise
5.8: Administration
  • Admin Portal
  • Set Power BI Administrator
  • Tenant Settings
  • Audit Log
5.9: Row Level Security
  • Row Level Security in Power BI; regardless of Data Source
  • Row Level Security in SSAS Live Connection
  • Dynamic Row Level Security
5.10: Integration
  • Analyze in Excel
  • Power BI Publisher for Excel
  • Reporting Services and Power BI
  • Power BI and Power Point
5.11: Real-time
  • REST API of Power BI
  • Real-time Tiles
  • Azure Stream Analytics
5.12: Architecture
  • Architecture for Enterprise Scale
  • Architecture for Reporting
  • Architecture for Self-Service
  • Licensing

 

Instructor: Reza Rad

Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, PASS BA Conference, SQLBits, TechEds, Ignites, and many other conferences.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star

 

 

What others say about the training and trainer

 

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

Time

20 (Monday) 9:00 am - 24 (Friday) 4:30 pm

Organizer

Reza Radreza@radacad.com

Learn More
Wellington CBD
10sep - 14All DayAdvanced Analytics and Machine Learning - Wellington
Event Details

Register Here

more

Event Details
Register Here
Advanced Analytics – in-person Instructor Led 5-days Course

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

This training is 5 days of training using Machine Learning and R with SQL Server, Power BI, and concepts of Machine Learning.

Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Length: 5 days

 

Prerequisite: This course is a beginner to advanced level course. You don’t need any prerequisites for attending in this course. Instructor: Dr. Leila Etaati

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

In 5 days course, you will learn how to do machine learning in cloud using Azure ML, learn about basics of R, how to use R inside Power BI and R in SQL Server 2016:

Azure ML Studio and Azure ML Workbench (1.5 day )

The basics of Machine Learning

Some basics concepts will be explained like Process of machine learning,

What is descriptive, predictive and prescriptive, what is Cortana and how Azure ML can be used

Import data: The main component for importing data from local PC, how to import data from other work space, how to import data from html website, how to import data from cloud such as Azure SQL DB.

Data Cleaning: data cleaning is the main process that we should done before any machine learning process. I will explain the available component in Azure ML. Cleaning missing value, remove duplicate data, select column, clip value (remove outliers), group data into bins, create indicator for data, how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.

4- Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using sampling approach, how to create different folds for aim of cross validation.

5- Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example on prediction a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented, different algorithms will apply for a problem. the main concepts of k-mean , how to use elbow chart to identify the number of cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content based filtering  and hybrid approach for recommendation will be discussed.

5- Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross validation, how to do cross validation to apply a model to different folds of data, how to check the different values for an each parameters and see the related accuracy to that.

6-Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be show. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate model, enter data manually component and add row component.

7-Publish to Web:  the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.

8-Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to csv and other formats will be shown.

9-Using Azure ML Workbench for deploying the models for Data wrangling and data visualization

10- Model and experiment Managment in cortana

11- A brife explanation on Python

Introduction to R (0.5 days)

The basics of R will be shown in class

R basics:  the basics of R and data structure, like vector, list, data frame and factor will be discussed. The R studio environment will be shown how to write the R code, what is packages, how we can import data set into R using RStudio environment, how to import data from SQL Server, how to write SQL statement for data wrangling inside R studio,

Statistics: some of the main statistics computation will be explained, str, summary command, what is mean, median, first quarter, third quarter, standard deviation, and so on, how to show them using boxplot, and normal distribution. How to analysis data via these simple statistics.

Packages: how to install packages by writing code and without writing code, how to manage the packages, how to use dplyr package for data cleaning and wrangling, how to use ggplot2 package to draw pictures. Introduce some of the packages for drawing maps like leaflet and so on.

R and Power BI for Visualization and Machine Learning (2.5 days)

In this session, I will talk how to empower BI using R. this has four main section from how to draw R visual that we do not have normally in Power BI, how to create a R custom Visual for better usage and sharing with other, how to do machine learning and do different algorithms inside Power BI and finally how to use the available custom visual in office store.

Draw R visual in Power BI: in this session, I will show how to set up power BI to use R, how to create R visual inside power bi, how to debug and run code there, how to avoid some usual mistake to get better visualization. Some of the visual from ggplot2 package will be introduced. The Facet chart to show 5 different variables in a chart, how to show different types of chart in facet chart, how to create slope chart just to show the difference of a variable in two dimension (e.g. two time). How to draw a column width chart to show a bar chart with different weight, how to draw polar chart from our bar charts in different ways, how to draw a correlation chart for correlation analysis, how to draw a calendar chart, how to draw a map chart with desire sub chart in it and so on.

Create a Custom Visual chart:  the main process of how to create a custom R visual will be explained. From installing desired component to writ e the code in command prompt to create a template. How to change the r files, how to change the name of chart using json files, how to create pbiviz file so you able to import it into power bi. Moreover, the plotly package will be shown and how it makes the visual more interactive than before.

Machine Learning Algorithms with R and Power BI: in this part I am going to show how to do machine learning inside Power BI with a brief explanation on different algorithms.

I will show how to do machine learning inside power query using R transformation component, how to write R scripts to create some functions inside Power Query for more data transformation. Moreover the brief description of some algorithms with their R codes and required packages in R will be discussed.

K-Nearest neighbour: the main concepts for using KNN, how it works the statistic behind it, how to enhance and improve it, how to write the relevant code inside Power BI. Moreover, a discussion on overfitting and under fitting will be done. And how identify the best K value can help us in KNN algorithm.

Clustering with k-mean: what is the k-mean already discuss in first day. How to identify the number of cluster using elbow chart. How to analysis a clustering problem in power bi using power BI visuals.

Decision tree: the concepts behind it, how to specify the best value for decision tree depth and other parameters. How decision tree can be good for predicting a group, predict a value and also do the feature selection. How to draw a decision tree inside power bi and how to use it just for prediction.

Neural Network: the main concepts behind the neural network, the different structure for neural network, how to identify the best number of the hidden node, how to do prediction a group and a value using NN. How to show a NN structure in power bi.

Regression: the concepts behind the regression and some simple statistics will be provided. How to use if for predicting a value and how to evaluate the result of a regression will be shown. The liner and none linear regression also will be discussed

Market Basket Analysis: the main concepts for market basket analysis, the concepts of supports, confidence and lift will be shown, and how to show it in power bi will be discussed.

Time series: a detail concepts for time series will be presented. From simple time series without trend and seasonality and stationary one with no correlation between residual to Arima model with trend and seasonality (almost 6 different mode) will be discussed. The composite chart the exponential smoothing approach, the ACF and PCAF chart to identify the autocorrelation will be shown. Also, audience will learn how to draw a relevant time series chart using R codes in Power BI.

The optimization problem: a very brief introduction into optimization problem will be done, people will be familiar with linear programming. How to do it in Excel using Solver and how to do it in R and Power BI.

 

Power BI Office Store visual:   in this part, I will show some of existing power BI custom R visual that Microsoft provided them in Office store such as decision tree charts, accusative rules charts, clustering, time series for Arima model, Time series for exponential smoothing, decompose time series and so on. I will show how to setup the parameters and how to use them.

 

Using R services and ML services in SQL Server and Azure Data Lake(0.5 day)

How to set up: There is a possibility to do machine learning inside SQL Server 2016 using R codes. In half day audience, will be familiar how to set their SQL Server to access the R server for doing the machine learning. They learn how to call a store procedure for using an external code like R.  moreover, they learn how to use external scripts for doing machine learning writing R codes inside SQL Server, how to pass the data to R and how to get the output.

Best practice and Examples: Audience will learn the best practice for doing machine earning inside the SQL Server, create separate store procedures. A customer churn example will be shown. This example is for prediction.

Evolutionary Package: there is a package that most of Microsoft algorithms are there. I will show how to use these algorithms and what algorithms are exist in this package.

Draw R charts in SSRS: I will show how to create a R chart inside SQL Server Management studio and store it as binary value in a table. Finally, how to show it in SSRS.

 Azure Data Lake: I will show how to write R scripts inside Azure Data Lake and also how to explor the Azure data lake file inside RStudio

 

This course is full of hands on labs, and you will experiment all examples through real-world demos. At the end of the 3-day training course, you will be able to use techniques and concepts of this training in your Analytics challenges.

Instructor: Dr. Leila Etaati

Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

 

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

 

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

 

Save

Save

Save

Save

Save

Time

10 (Monday) - 14 (Friday)

Organizer

Leila Etaatileila@radacad.com

Learn More
Wellington CBD
10sep - 14sep 109:00 amsep 14Power BI from Rookie to Rock Star - Wellington
Event Details

Register Here What others say

more

Event Details
Register Here

What others say about the training and trainer;

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, United States

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

 

Course Details

Dates Monday, 7 May 2018 9.00AM

– Friday, 11 May 2018 4.30PM

This is the most comprehensive course for Power BI which split in daily modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are list and detailed agenda of each module:

  • Module 1: Power BI Essentials  – Day 1
  • Module 2: Advanced Power Query and Data Transformation – Day 2
  • Module 3: Advanced Data Modeling in Power BI with DAX – Day 3
  • Module 4: Advanced Data Visualization in Power BI – Day 4
  • Module 5: Advanced Gateways, Power BI Service, Administration, and Architecture – Day 5

 

Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

 

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

 

1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

 

 

1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • %Mate_Title%

  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

 

1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced

 

1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization

 

1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways

 

1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh

 

Module 2: Advanced Power Query and Data Transformation in Power BI

This course is module 2 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Agenda;

2.1: Get Data
  • Different Data Sources
  • What is Power Query?
  • Power Query in Excel and Power BI
  • Basic Transformations
  • Get Data from Web
2.2: Query Editor
  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from SQL Server
  • Get Data from CSV Files
  • Get Data from Excel
  • Get Data from JSON
  • Transformation Pane
2.3: Power Query Syntax
  • Data Types in Power Query
  • Query Properties
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
2.4: Combine Queries
  • Merge, Joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder
2.5: Transformations
  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Add as new query / Drill Down
2.6: Table Transformations
  • Group By
  • Extending Group By with Expression Editor
  • Transpose
  • Pivot, Unpivot
2.7: Text Transformations
  • Split
  • Merge (Concatenate)
  • Parse
  • Extract
2.8: Numeric Transformations
  • Standard
  • Scientific
  • Statistics
2.9: More Transformations
  • Date Transformations (Year, Month, Quarter)
  • Extending Fiscal Date Column
  • Time Transformations
  • Adding Time/Date banding
  • Structured Column
  • Expand
  • Aggregate
  • Add Custom Column
2.10: Power Query Formula Language: M
  • What is M? and the importance of learning M
  • M Syntax
  • Things to Consider for M Scripting
  • Basic examples of M
  • Values in M
  • Logical Operations
2.11: Advanced M Scripting
  • #Shared Keyword; function library of Power Query
  • Parameters
  • Custom Functions
  • Error Handling in Power Query
  • Generators in Power Query: Implementing Loop Structure
  • EACH singleton function
2.12: Use Cases
  • Date Dimension with Power Query
  • Day Number of Year Custom Function
  • Looping through files in a folder with Power Query
  • Online Date Time Scheduler with Power Query

 

Module 3: Advanced Power BI Modeling and DAX

This course is module 3 of the Power BI from Rookie to Rock Star course.

In this course, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Agenda;

3.1: Power BI Modeling 101
  • Relationship in Power BI
  • Relationship based on multiple Columns
  • Role Playing Dimension
  • Formatting
  • Hide/Unhide
  • Hierarchy
  • Basic Calculated Column and Measure
  • Sort by Column
3.2: Introduction to DAX
  • Syntax of DAX
  • Naming in DAX
  • Logical Operations
  • Data Types in Power BI Model
  • Overview of Functions
  • Variables
3.3: Functions in DAX in Details
  • Text Functions
  • Information Functions
  • Logical Functions
  • Date and Time Functions
  • Aggregation Functions
3.4: Filter, Value, and Relationship Functions
  • ALL
  • Examples of using ALL function
  • Filter Function
  • Related
  • RelatedTable
3.5: Evaluation Contexts
  • Row Context
  • Filter Context
  • Exception for Row Context
  • Exception for Filter Context
  • Calculate Function
3.6: Time Intelligence Functions
  • Year to Date, Quarter to Date
  • Fiscal Year to Date
  • Same Period Last Year
  • Running Total
  • Rolling 12 Month Sales
  • Average 12 Month Sales
  • Rolling 6 Months
  • Flexible banding
3.7: Calculated Tables
  • Role Playing Dimension
  • Top 10 Customers
  • More Scenarios of Using Calculated Tables
  • Performance Consideration
3.8: Best Practices Tips and Tricks
  • Solving DAX Now and Today Time zone Issue
  • Modeling Best Practices
  • Advanced Time Intelligence
  • Advanced Relationship in DAX
  • Hierarchies in DAX

 

Module 4: Advanced Data Visualization with Power BI

This course is module 4 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about data visualization in Power BI. Day starts with basics of visualizations of basic charts. You will learn best practices and considerations for coloring, choosing the right visual, numeric visualization and many other tips through the course. You will learn about custom visuals, how to build custom visuals. all tips and tricks in visualizations including filters, slicers, drill down/up, best practices of map visualizations and many other real-world examples with hands on lab and lecture. You will leave this course with a Jedi level of visualization.

Agenda;

4.1: Visualization Basics
  • Basic Charts
  • Clustered vs Stacked
  • Quick Calcs in Power BI
  • Interaction of Visuals
  • Pages
4.2: Visualization Best Practices
  • Pie Chart; Be Careful
  • Coloring
  • Show me the Numbers
  • Which Chart is the Best?
  • Story Telling
  • Combining Visuals
4.3: Slicing and Dicing
  • Filters
  • Slicers
  • Filtering Slicers
  • Drill Down/Up
4.4: Custom Formatting Visuals
  • Labels
  • Legend
  • Color
  • Extended visualization formatting
  • Group / bin
4.5: Special Visuals
  • Waterfall Chart; Cashflow
  • Scatter Chart; Story Telling
  • Line Chart; Powerful
  • Table and Matrix with Conditional Formatting
  • R Visualization
4.6: Map Visualization
  • Default map visual
  • Filled Map; Good, bad, and the ugly
  • Shape Map
  • Custom Map Visuals
  • ArcGIS
4.7: Custom Visuals
  • Using Custom Visuals
  • SynopticPanel by SQLBI
  • Chicklet Slicer
  • 3D Map with GlobeMap Visual
  • Sunburst
  • Time Slicers
4.8: KPIs in Power BI
  • KPI Default visual
  • Dial Gauge
  • Linear Gauge
  • Bullet Chart
4.9: Building a Custom Visual
  • Basics of scripting language
  • Writing first simple custom visual
  • Components of a custom visual component

 

 

 

Module 5: Power BI Service, Gateways, and Architecture

This course is module 5 of the Power BI from Rookie to Rock Star course.

In this course, you will learn everything about Power BI Service. Difference of dashboard and Report. Setting up a gateway. Difference of personal and on-premises gateway. You will learn all tips and tricks of configuration and installation and performance of gateway to connect Power BI on cloud report to on-premises data source and schedule it to refresh. You will also learn about DirectQuery and LiveQuery and difference between these two method. You will learn about architecting a solution with Power BI considering integration options of Power BI with other applications. You will also learn all tips about sharing and security with best practices. This course will be delivered in lecture style plus hands on lab experiments.

Agenda;

5.1: Gateways
  • What is Gateway?
  • Two types of Gateway
  • Personal Gateway; an example
  • On-premises Gateway; not only for Power BI
%Article_Title% 5.2: On-premises Gateway in Details
  • Requirements for on-premises gateway
  • Architecture Flow diagram of the gateway
  • Installation and Configuration considerations
  • Install and Configure Gateway example
  • Data Source Definition in Power BI Service
  • Schedule Refresh
5.3: Gateway Performance
  • Performance Considerations
  • Limitations of Gateway
  • Gateway for SSAS Live data source
5.4: DirectQuery
  • Step beyond 1/10GB Limitation in Power BI
  • Limitations of DirectQuery
  • Dashboard and Report considerations for DirectQuery
  • Performance Considerations
5.5: Live Query
  • Using SSAS Live data source
  • Difference of DirectQuery and Live Query
  • Enterprise Scale architecture
  • UPN Mapping
  • Architecture of Gateway and SSAS Live Connection
5.6: Power BI Service
  • Dashboard vs Report
  • Dashboard Tiles
  • Data Classification
  • Power Q&A
  • Tips and Tricks for Power Q&A
5.7: Sharing
  • Dashboard Sharing
  • Work Groups in Power BI
  • Content Packs
  • Publish to Web
  • Comparison of all Sharing methods
  • Sharing Architecture for enterprise
5.8: Administration
  • Admin Portal
  • Set Power BI Administrator
  • Tenant Settings
  • Audit Log
5.9: Row Level Security
  • Row Level Security in Power BI; regardless of Data Source
  • Row Level Security in SSAS Live Connection
  • Dynamic Row Level Security
5.10: Integration
  • Analyze in Excel
  • Power BI Publisher for Excel
  • Reporting Services and Power BI
  • Power BI and Power Point
5.11: Real-time
  • REST API of Power BI
  • Real-time Tiles
  • Azure Stream Analytics
5.12: Architecture
  • Architecture for Enterprise Scale
  • Architecture for Reporting
  • Architecture for Self-Service
  • Licensing

 

Instructor: Reza Rad

Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, PASS BA Conference, SQLBits, TechEds, Ignites, and many other conferences.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star

 

Register Here:

https://www.eventbrite.com/e/power-bi-from-rookie-to-rock-star-wellington-september-2018-tickets-40334663063

 

 

What others say about the training and trainer

 

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

Time

10 (Monday) 9:00 am - 14 (Friday) 4:30 pm

Organizer

Reza Radreza@radacad.com

Learn More
Online
17sep - 21All DayPower BI from Rookie to Rock Star – US East September 2018
Event Details

Register Here Course Title: Power

more

Event Details
Register Here Course Title: Power BI from Rookie to Rock Star Length:

Online: 5 days (Lecture + Labs) – 5 Modules; 1 day Essentials (Module 1), 4-days Advanced (Modules 2-5).

Instructor: Reza Rad

In this training course you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Components such as Power Query (Get Data and Transform), Modeling and DAX, Visualization, Power BI Desktop as the main tool, Power BI Service, Gateway configuration, and architecture. You will learn all the concepts with live demos. Expect learning best practices with great scenarios in this course.

Online Instructor Led.

Time in your area

Start: Monday, September 17, 2018
End: Friday, September 21, 2018
Time: 9:00am – 4:30 pm PDT

Suitable time for these cities:
Abidjan, Abuja, Acapulco, Accra, Aguascalientes, Albuquerque, Alert, Algiers, Asuncion, Atlanta, Augusta, Austin, Baker Lake, Baltimore, Bamako, Bangui, Banjul, Basse-Terre (Guadeloupe), Basseterre (St. Kitts), Belém, Belfast, Belmopan, Billings, Bismarck, Bissau, Blanc-Sablon, Bogota, Boise, Boston, Brasilia, Brazzaville, Bridgetown, Buenos Aires, Calgary, Cancún, Caracas, Cardiff, Casablanca, Castries, Cayenne, Charleston, Cheyenne, Chibougamau, Chicago, Columbia, Columbus, Conakry, Concord, Coral Harbour, Córdoba, Dakar, Dallas, Danmarkshavn, Denver, Des Moines, Detroit, Douglas, Dover, Dublin, Easter Island, Edinburgh, Edmonton, El Aaiún, Eureka, Fort-de-France, Fortaleza, Freetown, Galapagos Islands, George Town (Cayman), Georgetown (Guyana), Glasgow, Grise Fiord, Guadalajara, Guatemala City, Guayaquil, Halifax, Hamilton, Happy Valley-Goose Bay, Hartford, Havana, Hermosillo, Houston, Indianapolis, Inuvik, Ittoqqortoormiit, Jackson, Jamestown, Kangerlussuaq, Kansas City, King Edward Point, Kingston, Kingstown, Kinshasa, Knoxville, Kuujjuaq, La Paz, Lagos, Las Vegas, Libreville, Lima, Lincoln, Lisbon, Little Rock, Lomé, London, Los Angeles, Louisville, Luanda, Madison, Malabo, Managua, Manaus, Mary’s Harbour, Mazatlan, Mexicali, Mexico City, Miami, Midland, Milwaukee, Minneapolis, Monrovia, Montevideo, Montgomery, Montpelier, Montreal, Nashville, Nassau, Ndjamena, New Orleans, New York, Newark, Niamey, Nouakchott, Nuuk, Oklahoma City, Orlando, Ottawa, Ouagadougou, Panama, Paramaribo, Pensacola, Philadelphia, Phoenix, Pond Inlet, Ponta Delgada, Port-au-Prince, Port of Spain, Portland, Porto Novo, Praia, Providence, Punta Arenas, Qaanaaq, Québec, Quito, Rabat, Raleigh, Rapid City, Recife, Regina, Resolute Bay, Reykjavik, Richmond, Rio Branco, Rio de Janeiro, Roseau, Sacramento, Saint George’s, Saint John (CA – NB), Saint John’s (Antigua), Salem, Salt Lake City, Salvador, San Diego, San Francisco, San Jose (CR), San Jose (USA), San Juan, San Salvador, Santiago, Santo Domingo, São Paulo, São Tomé, Seattle, Sioux Falls, St. John’s (CA – NF), St. Louis, St. Paul, Stanley, Sucre, Tegucigalpa, Thule Air Base, Tijuana, Timbuktu, Topeka, Toronto, Tórshavn, Tunis, Vancouver, Veracruz, Washington DC, Whitehorse, Winnipeg, Yamoussoukro, Yaoundé, Yellowknife

Power BI from Rookie to Rock Star

This is the most comprehensive course for Power BI which split in daily modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are list and detailed agenda of each module:

  • Module 1: Power BI Essentials
  • Module 2: Advanced Power Query and Data Transformation
  • Module 3: Advanced Data Modeling in Power BI with DAX
  • Module 4: Advanced Data Visualization in Power BI
  • Module 5: Advanced Gateways, Power BI Service, Administration, and Architecture
Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.
1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source
1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M
1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced
1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization
1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways
1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh
Module 2: Advanced Power Query and Data Transformation in Power BI

This course is module 2 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Agenda;

2.1: Get Data
  • Different Data Sources
  • What is Power Query?
  • Power Query in Excel and Power BI
  • Basic Transformations
  • Get Data from Web
2.2: Query Editor
  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from SQL Server
  • Get Data from CSV Files
  • Get Data from Excel
  • Get Data from JSON
  • Transformation Pane
2.3: Power Query Syntax
  • Data Types in Power Query
  • Query Properties
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
2.4: Combine Queries
  • Merge, Joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder
2.5: Transformations
  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Add as new query / Drill Down
2.6: Table Transformations
  • Group By
  • Extending Group By with Expression Editor
  • Transpose
  • Pivot, Unpivot
2.7: Text Transformations
  • Split
  • Merge (Concatenate)
  • Parse
  • Extract
2.8: Numeric Transformations
  • Standard
  • Scientific
  • Statistics
2.9: More Transformations
  • Date Transformations (Year, Month, Quarter)
  • Extending Fiscal Date Column
  • Time Transformations
  • Adding Time/Date banding
  • Structured Column
  • Expand
  • Aggregate
  • Add Custom Column
2.10: Power Query Formula Language: M
  • What is M? and the importance of learning M
  • M Syntax
  • Things to Consider for M Scripting
  • Basic examples of M
  • Values in M
  • Logical Operations
2.11: Advanced M Scripting
  • #Shared Keyword; function library of Power Query
  • Parameters
  • Custom Functions
  • Error Handling in Power Query
  • Generators in Power Query: Implementing Loop Structure
  • EACH singleton function
2.12: Use Cases
  • Date Dimension with Power Query
  • Day Number of Year Custom Function
  • Looping through files in a folder with Power Query
  • Online Date Time Scheduler with Power Query
Module 3: Advanced Power BI Modeling and DAX

This course is module 3 of the Power BI from Rookie to Rock Star course.

In this course, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Agenda;

3.1: Power BI Modeling 101
  • Relationship in Power BI
  • Relationship based on multiple Columns
  • Role Playing Dimension
  • Formatting
  • Hide/Unhide
  • Hierarchy
  • Basic Calculated Column and Measure
  • Sort by Column
3.2: Introduction to DAX
  • Syntax of DAX
  • Naming in DAX
  • Logical Operations
  • Data Types in Power BI Model
  • Overview of Functions
  • Variables
3.3: Functions in DAX in Details
  • Text Functions
  • Information Functions
  • Logical Functions
  • Date and Time Functions
  • Aggregation Functions
3.4: Filter, Value, and Relationship Functions
  • ALL
  • Examples of using ALL function
  • Filter Function
  • Related
  • RelatedTable
3.5: Evaluation Contexts
  • Row Context
  • Filter Context
  • Exception for Row Context
  • Exception for Filter Context
  • Calculate Function
3.6: Time Intelligence Functions
  • Year to Date, Quarter to Date
  • Fiscal Year to Date
  • Same Period Last Year
  • Running Total
  • Rolling 12 Month Sales
  • Average 12 Month Sales
  • Rolling 6 Months
  • Flexible banding
3.7: Calculated Tables
  • Role Playing Dimension
  • Top 10 Customers
  • More Scenarios of Using Calculated Tables
  • Performance Consideration
3.8: Best Practices Tips and Tricks
  • Solving DAX Now and Today Time zone Issue
  • Modeling Best Practices
  • Advanced Time Intelligence
  • Advanced Relationship in DAX
  • Hierarchies in DAX
Module 4: Advanced Data Visualization with Power BI

This course is module 4 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about data visualization in Power BI. Day starts with basics of visualizations of basic charts. You will learn best practices and considerations for coloring, choosing the right visual, numeric visualization and many other tips through the course. You will learn about custom visuals, how to build custom visuals. all tips and tricks in visualizations including filters, slicers, drill down/up, best practices of map visualizations and many other real-world examples with hands on lab and lecture. You will leave this course with a Jedi level of visualization.

Agenda;

4.1: Visualization Basics
  • Basic Charts
  • Clustered vs Stacked
  • Quick Calcs in Power BI
  • Interaction of Visuals
  • Pages
4.2: Visualization Best Practices
  • Pie Chart; Be Careful
  • Coloring
  • Show me the Numbers
  • Which Chart is the Best?
  • Story Telling
  • Combining Visuals
4.3: Slicing and Dicing
  • Filters
  • Slicers
  • Filtering Slicers
  • Drill Down/Up
4.4: Custom Formatting Visuals
  • Labels
  • Legend
  • Color
  • Extended visualization formatting
  • Group / bin
4.5: Special Visuals
  • Waterfall Chart; Cashflow
  • Scatter Chart; Story Telling
  • Line Chart; Powerful
  • Table and Matrix with Conditional Formatting
  • R Visualization
4.6: Map Visualization
  • Default map visual
  • Filled Map; Good, bad, and the ugly
  • Shape Map
  • Custom Map Visuals
  • ArcGIS
4.7: Custom Visuals
  • Using Custom Visuals
  • SynopticPanel by SQLBI
  • Chicklet Slicer
  • 3D Map with GlobeMap Visual
  • Sunburst
  • Time Slicers
4.8: KPIs in Power BI
  • KPI Default visual
  • Dial Gauge
  • Linear Gauge
  • Bullet Chart
4.9: Building a Custom Visual
  • Basics of scripting language
  • Writing first simple custom visual
  • Components of a custom visual component
Module 5: Power BI Service, Gateways, and Architecture

This course is module 5 of the Power BI from Rookie to Rock Star course.

In this course, you will learn everything about Power BI Service. Difference of dashboard and Report. Setting up a gateway. Difference of personal and on-premises gateway. You will learn all tips and tricks of configuration and installation and performance of gateway to connect Power BI on cloud report to on-premises data source and schedule it to refresh. You will also learn about DirectQuery and LiveQuery and difference between these two method. You will learn about architecting a solution with Power BI considering integration options of Power BI with other applications. You will also learn all tips about sharing and security with best practices. This course will be delivered in lecture style plus hands on lab experiments.

Agenda;

5.1: Gateways
  • What is Gateway?
  • Two types of Gateway
  • Personal Gateway; an example
  • On-premises Gateway; not only for Power BI
5.2: On-premises Gateway in Details
  • Requirements for on-premises gateway
  • Architecture Flow diagram of the gateway
  • Installation and Configuration considerations
  • Install and Configure Gateway example
  • Data Source Definition in Power BI Service
  • Schedule Refresh
5.3: Gateway Performance
  • Performance Considerations
  • Limitations of Gateway
  • Gateway for SSAS Live data source
5.4: DirectQuery
  • Step beyond 1/10GB Limitation in Power BI
  • Limitations of DirectQuery
  • Dashboard and Report considerations for DirectQuery
  • Performance Considerations
5.5: Live Query
  • Using SSAS Live data source
  • Difference of DirectQuery and Live Query
  • Enterprise Scale architecture
  • UPN Mapping
  • Architecture of Gateway and SSAS Live Connection
5.6: Power BI Service
  • Dashboard vs Report
  • Dashboard Tiles
  • Data Classification
  • Power Q&A
  • Tips and Tricks for Power Q&A
5.7: Sharing
  • Dashboard Sharing
  • Work Groups in Power BI
  • Content Packs
  • Publish to Web
  • Comparison of all Sharing methods
  • Sharing Architecture for enterprise
5.8: Administration
  • Admin Portal
  • Set Power BI Administrator
  • Tenant Settings
  • Audit Log
5.9: Row Level Security
  • Row Level Security in Power BI; regardless of Data Source
  • Row Level Security in SSAS Live Connection
  • Dynamic Row Level Security
5.10: Integration
  • Analyze in Excel
  • Power BI Publisher for Excel
  • Reporting Services and Power BI
  • Power BI and Power Point
5.11: Real-time
  • REST API of Power BI
  • Real-time Tiles
  • Azure Stream Analytics
5.12: Architecture
  • Architecture for Enterprise Scale
  • Architecture for Reporting
  • Architecture for Self-Service
  • Licensing
  • Power BI Free
  • Power BI Pro
  • Power BI Premium
Why Power BI Training?

Power BI is the newest Microsoft BI tool for data mash up, build modelling, and visualize it effectively. It supports mobile devices, it support self-service, and along with its great functionalities, it doesn’t require heavy development or production system.

Common Myths about Power BI

There are some myths about Power BI that sometimes prevents people and organization to move towards using this product. We’ve listed some of myths in following. Please note that these are Myths, and they are not right assumptions.

Myth 1: Power BI is a self-service Excel tool, and isn’t suitable for Enterprise Solutions.

There are many scenarios that Power BI has been used in enterprise solutions. Power BI features for data mash up (with the very powerful data transformation component: Power Query), and data modelling  based on xVelocity in-memory engine (Power Pivot), and great data visualization components such as Power View and Power Map, along with mobility support of this product, are rarely available in other products. We have designed, implemented and have seem many BI enterprise solutions based on Power BI within very large organizations.

Myth 2: Power BI is easy to use, and doesn’t require training course.

Power BI is an easy to use tool, but for basic functions. Every BI application requires calculated measure, which needs to be written in DAX. Every BI application requires advanced data transformations which need to be handled with Power Query M scripting language. Designing and implementing solutions with Best Practices is always a requirement for reliable BI applications. We designed our Power BI training in a way that delivers advanced content for all components of Power BI, and fortify your team’s knowledge on the product, so they can solve any complex challenge with this tool.

Myth 3: Power BI is only for Microsoft based environments and platforms.

Power Query is the core of data extraction in Power BI. Power Query supports wide range of data sources. Not only SQL Server, but also Oracle, MySQL, web service result set, DB2 and many other data source are supported. There is also possibility to connect to many systems such as salesforce. The Visualization component of Power BI is also HTML5 supported, and is available for all mobile devices. Power BI app in AppStore, and Google PlayStore as well as Microsoft AppStore enables dashboards and data visualizations to be available in all environments.

Myth 4: Power BI is not a powerful and fully functional BI tool, and cannot be compared with other tools in the market.

In fact the reverse is true. Power BI is such powerful that can be replacement of many other expensive BI tools in the market. We’ve been through scenarios of successful Power BI solutions that have been replacement of Cognos, IBM products, Oracle WB, SAP BO, and so on. Power BI has 5 powerful components that cover main aspects of BI and data analysis system.

In addition there are always possibility to use this as a hybrid approach and save lots of time and money along with great features that are only available in this product.

Instructor: Reza Rad

Our trainer is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI book from Rookie to Rock Star.

In-Person Training;

Our Power BI in person training will be held in high quality hotels with recommendation for hotel bookings for attendees. There will be special group rating fee as well as early bird and past attendees discount. for schedule of our in person training follow this link:

Online Training;

We run online training with GoToWebinar and GoToTraining applications. These applications provide highly reliable communication channel between instructor and attendees. For schedule of our online training follow this link:

Use the letter written for your boss to convince him/her to pay for your Power BI Training course

Check Schedule of upcoming events here

Check cancellation policies and rates here

Schedule of Power BI Trainings in 2017 What others say about the training and trainer

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, Ohio, USA

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.
Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.
After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.
I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

Who Attended RADACAD Training Courses

 

Time

17 (Monday) - 21 (Friday)

Organizer

Reza Radreza@radacad.com

Learn More
Online
17sep - 21sep 179:00 amsep 21Advanced Analytics and Machine Learning - US East September 2018
Event Details

 

more

Event Details
Register Here
Advanced Analytics – Live Instructor Led 5-days Course

Online

Time in your area

Start: Monday, September 17, 2018
End: Friday, September 21, 2018
Time: 9:00am – 4:30 pm PDT

Suitable time for these cities:
Abidjan, Abuja, Acapulco, Accra, Aguascalientes, Albuquerque, Alert, Algiers, Asuncion, Atlanta, Augusta, Austin, Baker Lake, Baltimore, Bamako, Bangui, Banjul, Basse-Terre (Guadeloupe), Basseterre (St. Kitts), Belém, Belfast, Belmopan, Billings, Bismarck, Bissau, Blanc-Sablon, Bogota, Boise, Boston, Brasilia, Brazzaville, Bridgetown, Buenos Aires, Calgary, Cancún, Caracas, Cardiff, Casablanca, Castries, Cayenne, Charleston, Cheyenne, Chibougamau, Chicago, Columbia, Columbus, Conakry, Concord, Coral Harbour, Córdoba, Dakar, Dallas, Danmarkshavn, Denver, Des Moines, Detroit, Douglas, Dover, Dublin, Easter Island, Edinburgh, Edmonton, El Aaiún, Eureka, Fort-de-France, Fortaleza, Freetown, Galapagos Islands, George Town (Cayman), Georgetown (Guyana), Glasgow, Grise Fiord, Guadalajara, Guatemala City, Guayaquil, Halifax, Hamilton, Happy Valley-Goose Bay, Hartford, Havana, Hermosillo, Houston, Indianapolis, Inuvik, Ittoqqortoormiit, Jackson, Jamestown, Kangerlussuaq, Kansas City, King Edward Point, Kingston, Kingstown, Kinshasa, Knoxville, Kuujjuaq, La Paz, Lagos, Las Vegas, Libreville, Lima, Lincoln, Lisbon, Little Rock, Lomé, London, Los Angeles, Louisville, Luanda, Madison, Malabo, Managua, Manaus, Mary’s Harbour, Mazatlan, Mexicali, Mexico City, Miami, Midland, Milwaukee, Minneapolis, Monrovia, Montevideo, Montgomery, Montpelier, Montreal, Nashville, Nassau, Ndjamena, New Orleans, New York, Newark, Niamey, Nouakchott, Nuuk, Oklahoma City, Orlando, Ottawa, Ouagadougou, Panama, Paramaribo, Pensacola, Philadelphia, Phoenix, Pond Inlet, Ponta Delgada, Port-au-Prince, Port of Spain, Portland, Porto Novo, Praia, Providence, Punta Arenas, Qaanaaq, Québec, Quito, Rabat, Raleigh, Rapid City, Recife, Regina, Resolute Bay, Reykjavik, Richmond, Rio Branco, Rio de Janeiro, Roseau, Sacramento, Saint George’s, Saint John (CA – NB), Saint John’s (Antigua), Salem, Salt Lake City, Salvador, San Diego, San Francisco, San Jose (CR), San Jose (USA), San Juan, San Salvador, Santiago, Santo Domingo, São Paulo, São Tomé, Seattle, Sioux Falls, St. John’s (CA – NF), St. Louis, St. Paul, Stanley, Sucre, Tegucigalpa, Thule Air Base, Tijuana, Timbuktu, Topeka, Toronto, Tórshavn, Tunis, Vancouver, Veracruz, Washington DC, Whitehorse, Winnipeg, Yamoussoukro, Yaoundé, Yellowknife

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

This training is three days of training using Machine Learning and R with SQL Server, Power BI, and concepts of Machine Learning.

Product Description Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Length: 5 days Prerequisite: This course is a beginner to advanced level course. You don’t need any prerequisites for attending in this course. Instructor: Dr. Leila Etaati

 

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

At this training, you will learn:

Day 1: Azure ML, R Basics

In the first day, you will be familiar with the basic concepts of Machine Learning in Azure ML and some basic concepts of R in R Studio and Microsoft Visual studio 2015. In Day 1 you will learn;

Azure ML:

  • The main functionality of Azure ML and how to set it up.
    • Login in Azure ML, create experiment in Azure ML
  • Different components in Azure environments
    • Data import and Export into Azure studio in “Dataset” component using “Import Data”, “Export Data”, “Enter Data Manually”.
    • Using “Reader” component to fetch data from cloud services
    • Data format conversion such as “Convert to CSV”, “Convert to Dataset”
    • Data Transformation learning with counts” Creates a transformation that turns count tables into features, so that you can apply the transformation to multiple datasets.
    • Manipulation: Add columns and rows, Apply SQL Transformation, Clean Missing Data, Join Data, Remove Duplicate Row, Select Column in Dataset.
    • Split and Sample: Partition and Sample and Split Data.
    • Scale and reduce: Group Data in Bins and Normalize Data.
    • Feature Selection: for predictive analytics
    • Write R scripts in Azure ML using” Execute R”
    • Using “Time series Anomaly Detection” Component to detect anomalies in the input time series data.
  • How to work with different algorithms in Azure ML and how to use them for predictive, descriptive and prescriptive analysis, such as
    • Classifications algorithms such as “Multiclass Decision Forest”,” Multiclass Neural Network”, “Two-class Boosted Decision Tree”.
    • Clustering k-means Clustering
    • Regression algorithms: Linear Regression, Bayesian Linear Regression.
  • How to evaluate created model and analysis the evaluation output using evaluate model component. And how to enhance the model accuracy via cross validation and feature selection
  • How to create a API from Created model and how to call the created API in Excel.
  • Suggestions for possible architecture when using Azure ML.
  • Practice to create a simple ML Experiment in Azure ML.

R:

  • The basic of R language.
  • Installing R studio, setting up R server in SQL Server, setting up R in power BI,
  • Main data structure in R such as Data frame, Vector and List.
  • Exploring and Understanding Data in R
    • Exploring numeric variable, categorical variable and relationship between variables, using summary and STR function
    • How to use some of the main packages in R such as ggplot2 to visualize data.
    • Creating a ggplot, Aesthetic mappings, Facets, Geometric objects, Statistical transformations, Position adjustments, Coordinate systems,
  • Data Transformation with dplyer
    • Functions like filter()  for Comparisons, Logical operators, Missing values. Or function “select”
  • sqldf to use SQL Statements for query dataset, RODBC for fetching data from SQL database
  • The main concepts of basic statistics and how they can be helpful like: mean, median, standard division, and so forth will be discussed.
  • Practice in R and using some packages

 

Day 2: R algorithms and Power BI

The main aim of days 2 is to learn some of main machine learning algorithms, and understand how they work and how they can solve different type of real life problems. You will familiar with these algorithms and their syntax in R, and how to use them in Power BI. Moreover, you will learn how to embed some R visualization in Power BI.

In day 2 you will learn;

  • How classification algorithm like KNN works. and its relevant code in R.
    • KNN concepts
    • Write the KNN in R code
    • How to evaluate the result
    • How to improve the result by changing related parameters
  • Decision Tree concepts and its relevant R codes
    • What is decision tree, the concepts and how it works
    • Introduce different type of decision tree algorithms that are more common.
    • Introduce Rpart packages, how to write the related R code in Rstudio and Rvisual studio
    • See the Rpart package in Power BI visual
    • Package C50 for decision tree how to evaluate result and how to improve the model
  • Associative Rules
    • Audience will learn the main concepts behid the Associative rules
    • Where to use it and how it brings insight for users
    •  They will learn to write the code in R
    • Become familiar with concepts such as support, confidence and Lift.
    • Learn how Apriori packages and algorithm works
    • How to evaluate the association rules result
    • How to display it in Power BI
    • How to improve the results
  • How to write R codes in Power BI for transformation, and also creating new queries
    • How to set up the R in Power BI
    • How to write Simple R code for correlation analysis in R
    • How to create R visuals in Power BI
    • Do data transformation in Power BI with R functions
    • How to create interactive R reports in Power BI
    • How to call azure ML API into Power BI
      • Shows how to create functions in Power BI to call the API from Azure ML
    • Create a prediction model in Power BI and show the result in visualization.

Day 3: R algorithms and SQL Server 2016

In third day, you will learn how to bring analytics and intelligence using SQL server 2016.  Moreover, you will also learn some other important machine learning algorithms.

In Day 3 you will learn:

  • Neural Network algorithm
    • The concepts behind it and how it works
    • The ksvm() function
    • Evaluate the model and how to improve the performance
  • Time series algorithm
    • Time series concept difference between seasonality and trend
    • The function that is used to create the time series model
    • How to improve and evaluate it
  • Regression algorithm
    • Concept behind the regression
    • Predict numeric data (e.g. using linear regression) the function used to do the linear regression
    • How to create a model that support the nonlinear models
    • Multiple regression, logistic regression and so forth
    • How to evaluate the results
  • Recommendation (content-based filtering and collaborative filtering).
    • What is recommendation and what is content filtering and collaborating filtering
    • How to implement content filtering and collaborative filtering
    • Using classification and clustering algorithms to create a recommendation system
    • Azure ML recommendation model

Moreover, you will learn how to use machine learning in SQL Server 2016 and in SSRS.

    • Set up SQL Server to run the R scripts
    • The best practice for implementing a prediction process in SQL Server 2016
    • Create a correlation analysis in SQL Server
    • Create a decision tree diagram in SSRS via writing code in R
    • See an end to end predictive analysis code from getting data, create models, evaluate models and publish the result.
    • Practice: creating a predictive solution in SQL Server 2016

 

This course is full of hands on labs, and you will experiment all examples through real-world demos. At the end of the 3-day training course, you will be able to use techniques and concepts of this training in your Analytics challenges.

Instructor: Dr. Leila Etaati

Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

 

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualisations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

Registration:

http://learn.radacad.com/product/advanced-analytics-live-instructor-led-3-days-course/

More Details:

http://radacad.com/advanced-analytics-training

Time

17 (Monday) 9:00 am - 21 (Friday) 4:30 pm

Learn More
6 Clayton Street Newmarket Auckland 1023, New Zealand
19nov - 23All DayAdvanced Analytics and Machine Learning - Auckland
Event Details

Register

more

Event Details
Register Here
Advanced Analytics – in-person Instructor Led 5-days Course

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

This training is 5 days of training using Machine Learning and R with SQL Server, Power BI, and concepts of Machine Learning.

Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Length: 5 days

Dates Monday 9.00AM to – Friday 4.30PM

 

Prerequisite: This course is a beginner to advanced level course. You don’t need any prerequisites for attending in this course. Instructor: Dr. Leila Etaati

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

In 5 days course, you will learn how to do machine learning in cloud using Azure ML, learn about basics of R, how to use R inside Power BI and R in SQL Server 2016:

Azure ML Studio and Azure ML Workbench (1.5 day )

The basics of Machine Learning

Some basics concepts will be explained like Process of machine learning,

What is descriptive, predictive and prescriptive, what is Cortana and how Azure ML can be used

Import data: The main component for importing data from local PC, how to import data from other work space, how to import data from html website, how to import data from cloud such as Azure SQL DB.

Data Cleaning: data cleaning is the main process that we should done before any machine learning process. I will explain the available component in Azure ML. Cleaning missing value, remove duplicate data, select column, clip value (remove outliers), group data into bins, create indicator for data, how to normalize the data, how to use SQL Statement for data transformation, how to use enter data manually, how to edit the data type, change the column name with edit metadata component, how to join data from different data resource , how to increase the number of low incidence in a dataset which unbalanced.

4- Feature Selection Data Sampling: the process of feature selection will be explained, how to split data, how to partition data using sampling approach, how to create different folds for aim of cross validation.

5- Models: a bit talk about the available models in Azure mL for predictive, descriptive, prescriptive and anomaly detection. An example on prediction a group, a value, clustering data and anomaly detection will be shown. For each scenario, an example will be presented, different algorithms will apply for a problem. the main concepts of k-mean , how to use elbow chart to identify the number of cluster will be discussed, the PCA chart will be explained. The trained model for recommendation “match box recommender” will be explained through a scenario. The main concepts of collaborative filtering and content based filtering  and hybrid approach for recommendation will be discussed.

5- Training and Scoring models: how to choose algorithms and how to train model and test model, what is cross validation, how to do cross validation to apply a model to different folds of data, how to check the different values for an each parameters and see the related accuracy to that.

6-Evaluate: how to evaluate a classification problem concepts of Accuracy, Recall, Precision, AUC will be discussed, the evaluation criteria for regression algorithm MAE, RMSE and so on will be show. How to evaluate and see the result of more than three algorithms on one dataset will be shown. Using different evaluate model, enter data manually component and add row component.

7-Publish to Web:  the process of creating a web service from a model will be discussed, how to check it in Excel will be shown, also how to use it in Stream Analytics as a function for data will be shown.

8-Sharing workspace, create projects: the process of how to share the workspace with others will be discussed, how to create a project for each experiment, how to create a trained model component for reuse, and a data transformed dataset, how to export datasets to csv and other formats will be shown.

9-Using Azure ML Workbench for deploying the models for Data wrangling and data visualization

10- Model and experiment Managment in cortana

11- A brife explanation on Python

Introduction to R (0.5 days)

The basics of R will be shown in class

R basics:  the basics of R and data structure, like vector, list, data frame and factor will be discussed. The R studio environment will be shown how to write the R code, what is packages, how we can import data set into R using RStudio environment, how to import data from SQL Server, how to write SQL statement for data wrangling inside R studio,

Statistics: some of the main statistics computation will be explained, str, summary command, what is mean, median, first quarter, third quarter, standard deviation, and so on, how to show them using boxplot, and normal distribution. How to analysis data via these simple statistics.

Packages: how to install packages by writing code and without writing code, how to manage the packages, how to use dplyr package for data cleaning and wrangling, how to use ggplot2 package to draw pictures. Introduce some of the packages for drawing maps like leaflet and so on.

R and Power BI for Visualization and Machine Learning (2.5 days)

In this session, I will talk how to empower BI using R. this has four main section from how to draw R visual that we do not have normally in Power BI, how to create a R custom Visual for better usage and sharing with other, how to do machine learning and do different algorithms inside Power BI and finally how to use the available custom visual in office store.

Draw R visual in Power BI: in this session, I will show how to set up power BI to use R, how to create R visual inside power bi, how to debug and run code there, how to avoid some usual mistake to get better visualization. Some of the visual from ggplot2 package will be introduced. The Facet chart to show 5 different variables in a chart, how to show different types of chart in facet chart, how to create slope chart just to show the difference of a variable in two dimension (e.g. two time). How to draw a column width chart to show a bar chart with different weight, how to draw polar chart from our bar charts in different ways, how to draw a correlation chart for correlation analysis, how to draw a calendar chart, how to draw a map chart with desire sub chart in it and so on.

Create a Custom Visual chart:  the main process of how to create a custom R visual will be explained. From installing desired component to writ e the code in command prompt to create a template. How to change the r files, how to change the name of chart using json files, how to create pbiviz file so you able to import it into power bi. Moreover, the plotly package will be shown and how it makes the visual more interactive than before.

Machine Learning Algorithms with R and Power BI: in this part I am going to show how to do machine learning inside Power BI with a brief explanation on different algorithms.

I will show how to do machine learning inside power query using R transformation component, how to write R scripts to create some functions inside Power Query for more data transformation. Moreover the brief description of some algorithms with their R codes and required packages in R will be discussed.

K-Nearest neighbour: the main concepts for using KNN, how it works the statistic behind it, how to enhance and improve it, how to write the relevant code inside Power BI. Moreover, a discussion on overfitting and under fitting will be done. And how identify the best K value can help us in KNN algorithm.

Clustering with k-mean: what is the k-mean already discuss in first day. How to identify the number of cluster using elbow chart. How to analysis a clustering problem in power bi using power BI visuals.

Decision tree: the concepts behind it, how to specify the best value for decision tree depth and other parameters. How decision tree can be good for predicting a group, predict a value and also do the feature selection. How to draw a decision tree inside power bi and how to use it just for prediction.

Neural Network: the main concepts behind the neural network, the different structure for neural network, how to identify the best number of the hidden node, how to do prediction a group and a value using NN. How to show a NN structure in power bi.

Regression: the concepts behind the regression and some simple statistics will be provided. How to use if for predicting a value and how to evaluate the result of a regression will be shown. The liner and none linear regression also will be discussed

Market Basket Analysis: the main concepts for market basket analysis, the concepts of supports, confidence and lift will be shown, and how to show it in power bi will be discussed.

Time series: a detail concepts for time series will be presented. From simple time series without trend and seasonality and stationary one with no correlation between residual to Arima model with trend and seasonality (almost 6 different mode) will be discussed. The composite chart the exponential smoothing approach, the ACF and PCAF chart to identify the autocorrelation will be shown. Also, audience will learn how to draw a relevant time series chart using R codes in Power BI.

The optimization problem: a very brief introduction into optimization problem will be done, people will be familiar with linear programming. How to do it in Excel using Solver and how to do it in R and Power BI.

 

Power BI Office Store visual:   in this part, I will show some of existing power BI custom R visual that Microsoft provided them in Office store such as decision tree charts, accusative rules charts, clustering, time series for Arima model, Time series for exponential smoothing, decompose time series and so on. I will show how to setup the parameters and how to use them.

 

Using R services and ML services in SQL Server and Azure Data Lake(0.5 day)

How to set up: There is a possibility to do machine learning inside SQL Server 2016 using R codes. In half day audience, will be familiar how to set their SQL Server to access the R server for doing the machine learning. They learn how to call a store procedure for using an external code like R.  moreover, they learn how to use external scripts for doing machine learning writing R codes inside SQL Server, how to pass the data to R and how to get the output.

Best practice and Examples: Audience will learn the best practice for doing machine earning inside the SQL Server, create separate store procedures. A customer churn example will be shown. This example is for prediction.

Evolutionary Package: there is a package that most of Microsoft algorithms are there. I will show how to use these algorithms and what algorithms are exist in this package.

Draw R charts in SSRS: I will show how to create a R chart inside SQL Server Management studio and store it as binary value in a table. Finally, how to show it in SSRS.

 Azure Data Lake: I will show how to write R scripts inside Azure Data Lake and also how to explor the Azure data lake file inside RStudio

 

This course is full of hands on labs, and you will experiment all examples through real-world demos. At the end of the 3-day training course, you will be able to use techniques and concepts of this training in your Analytics challenges.

Instructor: Dr. Leila Etaati

Dr. Leila Etaati gained her PhD in University of Auckland. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; PASS Summits, PASS Rally, SQL Nexus, Microsoft Ignite, and so on. She has more than 10 years experience in Data Mining and Analytics. She is also Microsoft Most Valuable Professional (MVP) because of her dedication on Microsoft Analytics and Machine Learning technologies. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

 

What others say about the training and trainer

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany:
I attended RADACADs “Advanced Analytics” course recently in Frankfurt in May 2017. Being a regular user of Power BI (with a science background ) the course was extremely helpful in showing me how to incorporate R data visualizations into Power BI dashboards and for introducing me to machine learning using the Microsoft ML Studio. Leila is an excellent and extremely knowledgeable instructor and explained complex data analytical concepts and methodologies in an easy-to-understand manner. I thoroughly recommend this course to anyone who wants to expand their data analytical skills and knowledge.

Martin Catherall (Microsoft Data Platform MVP):

As part of SQL Saturday Auckland 2016 I attended an “Analytics with Power BI and R.” pre-con with Leila. Leila took the class’s knowledge from rudimentary to competent in a day. We first looked at R, the language and the software. Once these skills were obtained we started to look at Power BI and the integration that it has with R. We worked through a few examples and Leila answered all of the class’s questions and offered to provide supplementary material for some of the more advanced questions. I left the class feeling that my R and Power BI knowledge was at a competent level and ready to dive into some of the more advanced material that Leila provided.

 

 

Cancellation:
Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

Transfer:
Transfer fee to another event date* (up to 2 weeks before event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before event): 40% of the standard price of the event to transfer

Transfer fee at the day of event*: 60% of the standard price of the event to transfer

*transfer can be done only once, and it can be only transferred to another date not later than 6 months from the original event.
No Show:
No fee will be refunded for no show.

 

Save

Save

Save

Save

Save

Time

19 (Monday) - 23 (Friday) NZDT

Location

6 Clayton Street Newmarket

Auckland 1023, New Zealand

Organizer

Leila Etaatileila@radacad.com

Learn More
6 Clayton Street Newmarket Auckland 1023 New Zealand
19nov - 23nov 199:00 amnov 23Power BI from Rookie to Rock Star - Auckland
Event Details

Register Here What others say

more

Event Details
Register Here

What others say about the training and trainer;

Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools, United States

I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

I would recommend Radacad Power BI Training without hesitation.

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

 

Course Details

This is the most comprehensive course for Power BI which split in daily modules. You can enroll in any of these modules separately or take the whole course. Modules designed independently, which means each module can be taken regardless of the order of modules. Here are list and detailed agenda of each module:

  • Module 1: Power BI Essentials  – Day 1
  • Module 2: Advanced Power Query and Data Transformation – Day 2
  • Module 3: Advanced Data Modeling in Power BI with DAX – Day 3
  • Module 4: Advanced Data Visualization in Power BI – Day 4
  • Module 5: Advanced Gateways, Power BI Service, Administration, and Architecture – Day 5

 

Module 1: Power BI Essentials

This course is module 1 of Power BI from Rookie to Rock Star Training

In this training course, you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

 

1.1: Introduction to Power BI

Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module, we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and Power Q&A.

 

1.2: Getting Data

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources, you can have a live or direct connection, for some connection works offline. For some connections, you need a gateway or connector to be installed. In this module, you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data from Excel: Everything You Need to Know
  • Definitive Guide to Power BI Personal Gateway and Enterprise Gateway
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data from Azure SQL Database
  • Azure SQL Data Warehouse Source
  • Software as A Source
  • Web Source

 

 

1.3: Power Query for Data Transformation

Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

 

1.4: Data Modelling and DAX

Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module, you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module, you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced

 

1.5: Data Visualization

Data Visualization is the front end of any BI application; this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization

 

1.6: Power BI Service, Dashboards, Q&A, and Gateways

Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However, there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module, you will learn best practices for modelling that effect on the response of Power Q&A.

The content that you will learn in this module includes but not limited to;

  • Power Q&A introduction
  • Design best practices for Power Q&A
  • Power BI Service
  • Dashboard vs Report
  • Gateways

 

1.7: Administration & Security

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription, or even SharePoint on-premises. In this module, we will go through deployment options, Configurations and requirements required for each environment. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone.

The content that you will learn in this module includes but not limited to;

  • Groups and Work Spaces
  • Sharing
  • Row Level Security
  • Schedule Refresh

 

Module 2: Advanced Power Query and Data Transformation in Power BI

This course is module 2 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about Power Query, from zero to hero. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture. After this course you will be able to implement any types of data transformation through Power Query in Excel or Power BI.

Agenda;

2.1: Get Data
  • Different Data Sources
  • What is Power Query?
  • Power Query in Excel and Power BI
  • Basic Transformations
  • Get Data from Web
2.2: Query Editor
  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from SQL Server
  • Get Data from CSV Files
  • Get Data from Excel
  • Get Data from JSON
  • Transformation Pane
2.3: Power Query Syntax
  • Data Types in Power Query
  • Query Properties
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
2.4: Combine Queries
  • Merge, Joining queries
  • Append, creating a big list
  • Combine Binaries; Looping through files in a folder
2.5: Transformations
  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Add as new query / Drill Down
2.6: Table Transformations
  • Group By
  • Extending Group By with Expression Editor
  • Transpose
  • Pivot, Unpivot
2.7: Text Transformations
  • Split
  • Merge (Concatenate)
  • Parse
  • Extract
2.8: Numeric Transformations
  • Standard
  • Scientific
  • Statistics
2.9: More Transformations
  • Date Transformations (Year, Month, Quarter)
  • Extending Fiscal Date Column
  • Time Transformations
  • Adding Time/Date banding
  • Structured Column
  • Expand
  • Aggregate
  • Add Custom Column
2.10: Power Query Formula Language: M
  • What is M? and the importance of learning M
  • M Syntax
  • Things to Consider for M Scripting
  • Basic examples of M
  • Values in M
  • Logical Operations
2.11: Advanced M Scripting
  • #Shared Keyword; function library of Power Query
  • Parameters
  • Custom Functions
  • Error Handling in Power Query
  • Generators in Power Query: Implementing Loop Structure
  • EACH singleton function
2.12: Use Cases
  • Date Dimension with Power Query
  • Day Number of Year Custom Function
  • Looping through files in a folder with Power Query
  • Online Date Time Scheduler with Power Query

 

Module 3: Advanced Power BI Modeling and DAX

This course is module 3 of the Power BI from Rookie to Rock Star course.

In this course, you will learn DAX from zero to hero. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modeling expression language in Power BI (and also SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real world challenges of a BI solution.

Agenda;

3.1: Power BI Modeling 101
  • Relationship in Power BI
  • Relationship based on multiple Columns
  • Role Playing Dimension
  • Formatting
  • Hide/Unhide
  • Hierarchy
  • Basic Calculated Column and Measure
  • Sort by Column
3.2: Introduction to DAX
  • Syntax of DAX
  • Naming in DAX
  • Logical Operations
  • Data Types in Power BI Model
  • Overview of Functions
  • Variables
3.3: Functions in DAX in Details
  • Text Functions
  • Information Functions
  • Logical Functions
  • Date and Time Functions
  • Aggregation Functions
3.4: Filter, Value, and Relationship Functions
  • ALL
  • Examples of using ALL function
  • Filter Function
  • Related
  • RelatedTable
3.5: Evaluation Contexts
  • Row Context
  • Filter Context
  • Exception for Row Context
  • Exception for Filter Context
  • Calculate Function
3.6: Time Intelligence Functions
  • Year to Date, Quarter to Date
  • Fiscal Year to Date
  • Same Period Last Year
  • Running Total
  • Rolling 12 Month Sales
  • Average 12 Month Sales
  • Rolling 6 Months
  • Flexible banding
3.7: Calculated Tables
  • Role Playing Dimension
  • Top 10 Customers
  • More Scenarios of Using Calculated Tables
  • Performance Consideration
3.8: Best Practices Tips and Tricks
  • Solving DAX Now and Today Time zone Issue
  • Modeling Best Practices
  • Advanced Time Intelligence
  • Advanced Relationship in DAX
  • %Article_Category%
  • Hierarchies in DAX

 

Module 4: Advanced Data Visualization with Power BI

This course is module 4 of the Power BI from Rookie to Rock Star course.

In this course, you will learn all things about data visualization in Power BI. Day starts with basics of visualizations of basic charts. You will learn best practices and considerations for coloring, choosing the right visual, numeric visualization and many other tips through the course. You will learn about custom visuals, how to build custom visuals. all tips and tricks in visualizations including filters, slicers, drill down/up, best practices of map visualizations and many other real-world examples with hands on lab and lecture. You will leave this course with a Jedi level of visualization.

Agenda;

4.1: Visualization Basics
  • Basic Charts
  • Clustered vs Stacked
  • Quick Calcs in Power BI
  • Interaction of Visuals
  • Pages
4.2: Visualization Best Practices
  • Pie Chart; Be Careful
  • Coloring
  • Show me the Numbers
  • Which Chart is the Best?
  • Story Telling
  • Combining Visuals
4.3: Slicing and Dicing
  • Filters
  • Slicers
  • Filtering Slicers
  • Drill Down/Up
4.4: Custom Formatting Visuals
  • Labels
  • Legend
  • Color
  • Extended visualization formatting
  • Group / bin
4.5: Special Visuals
  • Waterfall Chart; Cashflow
  • Scatter Chart; Story Telling
  • Line Chart; Powerful
  • Table and Matrix with Conditional Formatting
  • R Visualization
4.6: Map Visualization
  • Default map visual
  • Filled Map; Good, bad, and the ugly
  • Shape Map
  • Custom Map Visuals
  • ArcGIS
4.7: Custom Visuals
  • Using Custom Visuals
  • SynopticPanel by SQLBI
  • Chicklet Slicer
  • 3D Map with GlobeMap Visual
  • Sunburst
  • Time Slicers
4.8: KPIs in Power BI
  • KPI Default visual
  • Dial Gauge
  • Linear Gauge
  • Bullet Chart
4.9: Building a Custom Visual
  • Basics of scripting language
  • Writing first simple custom visual
  • Components of a custom visual component

 

 

 

Module 5: Power BI Service, Gateways, and Architecture

This course is module 5 of the Power BI from Rookie to Rock Star course.

In this course, you will learn everything about Power BI Service. Difference of dashboard and Report. Setting up a gateway. Difference of personal and on-premises gateway. You will learn all tips and tricks of configuration and installation and performance of gateway to connect Power BI on cloud report to on-premises data source and schedule it to refresh. You will also learn about DirectQuery and LiveQuery and difference between these two method. You will learn about architecting a solution with Power BI considering integration options of Power BI with other applications. You will also learn all tips about sharing and security with best practices. This course will be delivered in lecture style plus hands on lab experiments.

Agenda;

5.1: Gateways
  • What is Gateway?
  • Two types of Gateway
  • Personal Gateway; an example
  • On-premises Gateway; not only for Power BI
5.2: On-premises Gateway in Details
  • Requirements for on-premises gateway
  • Architecture Flow diagram of the gateway
  • Installation and Configuration considerations
  • Install and Configure Gateway example
  • Data Source Definition in Power BI Service
  • Schedule Refresh
5.3: Gateway Performance
  • Performance Considerations
  • Limitations of Gateway
  • Gateway for SSAS Live data source
5.4: DirectQuery
  • Step beyond 1/10GB Limitation in Power BI
  • Limitations of DirectQuery
  • Dashboard and Report considerations for DirectQuery
  • Performance Considerations
5.5: Live Query
  • Using SSAS Live data source
  • Difference of DirectQuery and Live Query
  • Enterprise Scale architecture
  • UPN Mapping
  • Architecture of Gateway and SSAS Live Connection
5.6: Power BI Service
  • Dashboard vs Report
  • Dashboard Tiles
  • Data Classification
  • Power Q&A
  • Tips and Tricks for Power Q&A
5.7: Sharing
  • Dashboard Sharing
  • Work Groups in Power BI
  • Content Packs
  • Publish to Web
  • Comparison of all Sharing methods
  • Sharing Architecture for enterprise
5.8: Administration
  • Admin Portal
  • Set Power BI Administrator
  • Tenant Settings
  • Audit Log
5.9: Row Level Security
  • Row Level Security in Power BI; regardless of Data Source
  • Row Level Security in SSAS Live Connection
  • Dynamic Row Level Security
5.10: Integration
  • Analyze in Excel
  • Power BI Publisher for Excel
  • Reporting Services and Power BI
  • Power BI and Power Point
5.11: Real-time
  • REST API of Power BI
  • Real-time Tiles
  • Azure Stream Analytics
5.12: Architecture
  • Architecture for Enterprise Scale
  • Architecture for Reporting
  • Architecture for Self-Service
  • Licensing

 

Instructor: Reza Rad

Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, PASS BA Conference, SQLBits, TechEds, Ignites, and many other conferences.  He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star

 

 

What others say about the training and trainer

 

Jeffrey Weir; Independent Consultant, Wellington, New Zealand

I learned a lot from this course: it gave a great overview of what’s possible both right from the UI, and what more awaits if you lift the hood and pimp the engine. It’s incredible to see just how much PowerBI and PowerQuery radically simplify what I would otherwise have to do with many, many lines of complicated VBA code. And Reza is a masterful user of this tool.

Note that Reza covers a lot of ground in this course, and it is pretty fast paced. While you can take a laptop and follow along as Reza takes PowerBI/Powerquery through its paces, for the one-day course my recommendation would be to keep that laptop closed, and simply sit back and watch Reza in action, so you can fully concentrate on just how simple this tool is to use in the right hands as well as think about how you might use the tool to your own ends and ask questions along those lines. You can always purchase the video course (if it’s not already included in your course) and step through the material again at your own pace.

Rob Wilby; Independent Consultant, UK

I must say your “Power BI Essentials” course has been the most comprehensive Power BI course I have found to date and seeing how you work with data especially the little tricks naturally introduced at just the right moments has made this course a pleasure to take.

Martin Catherall – Data Platform MVP, PASS Regional Mentor

I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.

Dan Cheshire, Senior Project Manager Air New Zealand

Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.

Sonia Buckley, Data Analyst at Zoom2u, Sydney, Australia

We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!

Time

19 (Monday) 9:00 am - 23 (Friday) 4:30 pm NZDT

Location

6 Clayton Street Newmarket

Auckland 1023 New Zealand

Organizer

Reza Radreza@radacad.com

Learn More
1370692
4474197
6446961
7338132
10946001
11209672
13695153
15169856
16080082

© 2018 RADACAD All Rights Reserved.