Tag: Documentation

Find Error DAX Expressions, Export Tables, Gateway and APP Documentation all in Power BI Helper July 2019 Edition

Posted on July 26, 2019 by Reza Rad

What if you can find all details about DAX measures, and find all of the expressions that have an error in their syntax? Power BI Helper July 2019 version can do that for you. But not just that, it can also export a data table into CSV format, no matter how big it is. In Read more about Find Error DAX Expressions, Export Tables, Gateway and APP Documentation all in Power BI Helper July 2019 Edition[…]

Posted in DAX, Power BI, Power BI HelperTagged DAX, Documentation, Power BI, Power BI Helper, ServiceLeave a comment

Search for:

Academy Membership

Follow Reza on Twitter

Follow @Rad_Reza

Follow Leila on Twitter

Follow @leila_etaati

Sort Options

Sort By:

date

Date

Crown Promenade Crown Promenade Melbourne

20aug9:00 am- 5:00 pmAustralia Summit Pre-Con: AI in Power Platform, an Impossible Realm - Melbourne, Australia

Event Details

Register Here

Attend this session to learn how to consume Pre-Built AI tools like cognitive services and Custom AI tools such as Azure ML Studio and Services, R and others in Power BI. Also, they will learn how to create smart applications using Power Apps, Flow and Cognitive Services.

There is a huge need to use AI in different applications and platforms. Likewise, doing AI and ML is also possible to be done in Power Platform (Power BI, Microsoft Flow and Power Apps). This workshop has two main modules and each module has different sections as below:

Module 1 : AI in Power BI
Using AI and ML in Power BI desktop and services is possible for both business users and developers. They can consume the cognitive service API and Azure mL Studio and Services web service in their Power BI reports and dashboards.

Cognitive service:
In this module, how we able to consume Pre-Built AI in Power BI as a business user or developer will be discussed. The audiences get familiar with cognitive service tools in general, and how to consume it in Power BI desktop as a developer or in Power BI service as a business user.

Azure ML Studio and Services:
The learner will see how to create a simple ML model in Azure ML Studio or services and then consume its web service in Power BI desktop as a developer or as a Business user in Power BI services. The audience learns how they able to consume the model that has been created by a data scientist and put in Azure ML Service and Studio and apply on their datasets.

Visualization and Embed AI in Power BI
Learners get familiar with some visuals in Power BI that provide more insight over data such as Key Influencer and Correlation chart. Also, some of the other features in Power BI that use AI such as QnA and enter by example and so forth will be shown. Also, the audience will learn how to use some simple R codes to export data from Power BI or

Module 2: AI Application with Power Apps and Microsoft Flow
Microsoft Power Apps and Flow make the creating application easier. The audience can consume the cognitive service to create some more smart applications like creating OCR, creating face recognition application, image detection and so forth.

Get Familiar with Power Apps and Flow
The audience will get familiar with the main concepts of Power BI and Flow and how they are working separately or together

Create an OCR application
The audience will learn how to create an OCR application with cognitive service, Power Apps and Flow.

Call any Cognitive Service API in MS Flow
Moreover, the audience will get familiar with how to call other cognitive services API like face API or Image tag API in Microsoft Flow in general. And create an Application

This workshop can be useful for business users who do not want to write python or R scripts for machine learning and still able to consume and get the advantage of AI in their reports and Power apps applications. Also, they are able to see some embed AI in Power BI to get more insight out of data.

It will benefit developers who want to access created models in Azure ML Studio and service and want to write simple R/Python codes to export data or doing regular expressions.

This workshop is also good for a data scientist to see how they are able to communicate with their data engineer and business users who use Power BI desktop, Power Apps and Microsoft Flow.

Instructor

Leila Etaati, MVP

Consultant
RADACAD, New Zealand

Time

(Tuesday) 9:00 am - 5:00 pm

Location

Crown Promenade

Crown Promenade Melbourne

Learn More

Crown Promenade Melbourne

20aug9:00 am- 5:00 pmAustralia Summit Pre-Con: Data Modeling Tips and Tricks in Power BI Using DAX and Power Query - Melbourne, Australia

Event Details

Register Here

This training is designed for data modeler, who have one or more data sources to get data from, prepare the data with transformations, build the models, relationships, and add some business calculations to it to get the full analytical power of Power BI. In this training, you will learn best practices of Power BI modelling, Power Query, and DAX.

You will learn how you can use Power Query to prepare data model in the proper way. You will learn about basics of relationships, cardinality of relationships, how to create shared dimension and star schema. You will learn about DAX patterns that can help with the calculations needed.
At the end of this training, you will be able to use Power Query for data preparation, design the proper data model in Power BI, understand all relationship requirements and implement the right relationship, write complex DAX expressions for your analytics need, and put them all together to build the best model for your data analysis solution using Power BI.

The training includes but not limited to topics below:
1: Get Data
In this section, you will learn about Power Query basics which starts with Getting data. You will learn that Power Query is the data transformation tool in Power BI. You will learn different parts of the Query Editor through an example of using Power Query to transform a dataset.

• Introduction to Power Query
• Query Editor
• Get Data from Web
• Basic Transformations
• Get Data from Excel
• Use First Row As Headers / Use Headers as First Row
• Get Data from SQL Server

2: Combine Queries to build dimensions and fact tables
One of the most common data transformations is combining datasets. Depends on the types of datasets and the way that they are related to each other, you may want to merge or append them. In this section, you will learn why you need to combine data at first, and then you will learn about scenarios that you combine data in Power Query.

• Dimensional Modelling; Designing the data model
• Append, creating a single big query of the same structure
• Merge; Joining queries when the structure is different
• Join types in Merge
• Tips to consider after Merge or Append

3: Table Transformations
Some of the most important table transformations will be explained in this section. You will learn about a way to change the granularity of a table; Grouping. You will also learn scenarios that grouping data can be more than a simple transformation. You will learn about transformations such as Transpose, Pivot and Unpivot, and the difference of all these items with scenarios of using it on real-world datasets.

• Group By; Changing the granularity of the data table
• Group by Advanced
• Scripting and Group by; First and Last item in each group
• Transpose; rows to columns and reverse
• Pivot; changing the name-value structure to columns
• Unpivot; changing the budget column structure to rows

4: Power BI Modelling
Power BI Modelling engine is based on the same engine used in Excel Power Pivot, and SQL Server Analysis Services Tabular. Power BI uses the in-memory engine, named xVelocity. The in-memory engine of Power BI makes the analysis super-fast. Everything will respond very fast in this model. In this section, you will learn about the basics of the modeling engine and some of the differences of that with SSAS and Power Pivot.

• Basics of Modelling in Power BI
• The step before this: Data Preparation
• Relationships in Power BI; Filter propagation
• Direction of Relationship
• Be Careful of both directional relationship
• Active or In-active relationships
• Relationship based on multiple Columns
• Role Playing Dimension
• Formatting
• Hide/Unhide Columns
• Hierarchy Definition in Power BI
• Sort by Column

5: Calculations in Power BI
There are three types of calculations in Power BI. Calculated Column, Measure, and Calculated Table. You can write DAX expression in all these three types of objects. This section will teach you what the main difference between the calculated column, measure, and the calculated table is, and what are scenarios of using them.

• Calculated Column; Row by Row
• Measure; Single Output
• Calculated Table; A derived table
• Calculated Column? Maybe a good candidate for Power Query transformation
• Measures are Dynamic

6: DAX Functions used in real-world scenarios
The last part of the training focused on using advanced DAX expressions in real-world scenarios, functions included but not limited to:

• Aggregation Functions and Iterators
• Filter Functions
• Relationship Functions
• Time Intelligence Functions
• Parent-child hierarchy functions
• Dynamic DAX

Instructor

Reza Rad, Microsoft Regional Director, MVP

Consultant, Trainer
RADACAD, New Zealand

Time

(Tuesday) 9:00 am - 5:00 pm

Location

Crown Promenade

Melbourne

Learn More

Istanbul TBD Turkey

2sep - 3sep 29:00 amsep 3RADACAD Bootcamp: Power BI and AI – Istanbul, Turkey

Event Details

Register Here

RADACAD Bootcamp is a 2-days course, run through our premier Power BI and AI content by Reza and Leila in-person. This event would be full of hands-on labs and designed in a way that gives you most of the training value in a short timeframe. If you haven’t used Power BI or AI technologies at all, and are a complete beginner, or on the other hand, if you are an advanced and experienced user, you will get a lot of learnings and takeaways from this course. The course is in two days modules:

Day 1: Power BI
Day 2: AI

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Length: 1 or 2 days.

Delivery method: In-Person

Dates: 2nd and 3rd of September 2019

Location: Istanbul, Turkey

Type of training: Public

Language: English

Full 2-days Bootcamp; $280

One day only: $170

Time

2 (Monday) 9:00 am - 3 (Tuesday) 4:30 pm TRT

Location

Istanbul TBD

Turkey

Organizer

Reza Radreza@radacad.com

Learn More

Auckland TBD Auckland, Auckland, New Zealand

24sep - 25sep 249:00 amsep 25Power BI from Rookie to Rock Star - Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course - Auckland

Event Details

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

The course is scheduled for Auckland’s time zone from 9:00 Am to 4:30 PM each day.

You can join this course online if you are in other countries and cities. We use the reliable channel of GoToMeeting (which is like Skype) for the course. You will be online at the same time as other students and instructor. We will have full-screen sharing, video and audio experience through GoToMeeting. You would be able to ask any questions you have and get responses directly from the instructor, and even share your screen to ask a question from the instructor in case needed.

The well-known worldwide training in Power BI field, and the most comprehensive Power BI training on the planet from one to nine days of training delivered by the well-known experts and MVPs, authors of books, and speakers of many conferences themselves. 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), Modelling 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. This course is designed in separate modules based on the type of audience. If you are a data analyst, data wrangler, data modeler, or data architect, or even a data scientist, this course has many things to teach you all.

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Our trainer is the world well-known name in the Microsoft BI field. Reza Rad is Microsoft Regional Director, a speaker in world’s best and biggest Microsoft Data Platform, BI and Power BI conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, and so on. He is the author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. Reza is the founder of RADACAD and a consultant for more than decades. He is also a Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis; Microsoft has awarded him MVP because of his dedication and expertise in Microsoft BI technologies from 2011 till now (more than eight years). He is the author of Power BI book from Rookie to Rock Star.

Power BI from Rookie to Rock Star

This is the most comprehensive course for Power BI on the planet which split in 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 a list and detailed agenda of each module:

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

This training is designed for data wrangler, data developer or data transformer, who have the raw data coming from one or more data sources and want to make it ready for further modeling and analytics. In this training, you will learn detailed data transformation practices of Power BI using Power Query.

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. Table transformations such as Pivot and Unpivot will be discussed, as well as specific column transformations such as date column transformations. 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. You will be able to work through your raw data and make it ready for modeling and analytics.

The training includes but not limited to topics below:

2.1: Get Data

In this section, you will learn about Power Query basics which starts with Getting data. You will learn that Power Query is the data transformation tool in Power BI. You will learn different parts of the Query Editor through an example of using Power Query to transform a dataset.

Introduction to Power Query
Query Editor
Get Data from Web
Basic Transformations
Get Data from Excel
Use First Row As Headers / Use Headers as First Row
Get Data from SQL Server

2.2: Data Types and Data Structures

Before going any further in learning Power Query, you need to understand about data structures and data types. There are three main data structures in Power Query; table, record, and list. You will learn about these types through an example of getting data from a JSON structure. You will also learn about data types and their differences.

Base data structures in Power Query
Get Data from JSON
Transforming Table, Record, and List
Data Types in Power Query
Query Operations
Enable Load; Performance Boost
Query Operations; Duplicate, and Reference

2.3: Combine Queries

One of the most common data transformations is combining datasets. Depends on the types of datasets and the way that they are related to each other, you may want to merge or append them. In this section, you will learn why you need to combine data at first, and then you will learn about scenarios that you combine data in Power Query.

Dimensional Modelling; Designing the data model
Append, creating a single big query of the same structure
Merge; Joining queries when the structure is different
Join types in Merge
Tips to consider after Merge or Append

2.4: Better Power Query Editor Experience

To get the best experience with Power Query Editor, you need to consider organizing your queries and steps in the right way. In this section, you will learn about actions you can do on steps, such as moving them up or down, splitting steps in a query, etc. You will also learn about organizing your queries in groups (folders).

Groups; Folders in Query Editor
Steps Operations
Splitting query steps
Moving steps up or down
Add as new query / Drill Down
Be Careful of Actions; Undo!

2.5: Reducing Number of Rows; Filtering

Filtering rows in Power Query is an important transformation especially when the dataset is big, or when the data needs to be cleaned. There are different ways of doing filtering in Power Query. You will learn about ways to remove some rows from the top or bottom of the table, and ways that you can filter a data table based on criteria. You will learn about basic filtering and the difference of that with the advanced filtering, and potential challenges that you may have through this process.

Row Operations; Removing rows
Row Operations; Keeping rows
Remove/Keep Errors
Remove/Keep Duplicates
Using Remove/Keep combination for troubleshooting report
Filtering based on Individual values
The dilemma of the basic filtering
Advanced Filtering
Sorting

2.6: Column Operations

A data table in Power Query can get big if you don’t care about columns. In this section, you will learn actions that you can do on columns, and what are best practices to make sure you have the best performance in your Power BI model considering columns in your tables. You will also learn about some generic column operations and transformations.

Column Operations
Choosing Columns
Removing Columns
Data Type Change
Locale consideration for the data type
Replace Values
Fill Down/Up; Very Useful for Excel

2.7: Table Transformations

Some of the most important table transformations will be explained in this section. You will learn about a way to change the granularity of a table; Grouping. You will also learn scenarios that grouping data can be more than a simple transformation. You will learn about transformations such as Transpose, Pivot and Unpivot, and the difference of all these items with scenarios of using it on real-world datasets.

Group By; Changing the granularity of the data table
Group by Advanced
Scripting and Group by; First and Last item in each group
Transpose; rows to columns and reverse
Pivot; changing the name-value structure to columns
Unpivot; changing the budget column structure to rows

2.8: Text Transformations

When you work with text values, there are many transformations you can apply. Transformations such as a split column, removing part of a text, or adding a prefix or postfix to it, concatenating some columns together, etc.

Split Column by Delimiter
Split Column by number of Characters
Split into rows instead of columns
Merge (Concatenate)
Format
The difference between Clean and Trim
Parse (XML or JSON)
Extract part of the text

2.9: Numeric Transformations

You will learn in this section how to do numeric transformations. We will talk about standard transformations such as divide and integer-divide. You will also learn about transformations such as rounding, statistics transformations, and even some scientific transformations and use cases for those items.

Standard transformations; Divide, Integer-divide, Multiply, Add etc.
Scientific transformations; logarithm, power square, etc.
Statistics transformations;
Rounding
Information functions; Is Even, Is Odd, and Sign.
Dealing with faults in Numeric calculations

2.10: Date and Time Transformations

There are many transformations applicable to date and time columns. You may want to fetch year part of a date or get the fiscal calculation of a date. You may want to calculate age based on the birthday or calculate the difference between two dates. You will learn all these items in this section, you will also learn about time zone consideration when working with current date and time in Power BI, and how you can resolve it in Power Query.

Date Transformations (Year, Month, Quarter, Week, etc.)
Extending Fiscal Date Column
Time Transformations (Hour, Minute, Second, etc.)
Adding Time/Date banding
Duration Transformation and Data Type
Age Calculation
Local Date or Time
Time zone consideration for Power BI

2.11: Structured Column Transformations

When you combine tables, you get a structured column as a result, which can be a table, list, or record in every value. There are several transformations you can apply on structured columns, which you will learn in this section. You will also learn what may be the potential issue with some of these transformations.

What is a Structured Column?
Expand
Aggregate
Expand and Aggregate: Performance Consideration

2.12: Add Column Transformations

There are two types of transformations in Power Query; Transforming an existing column, or adding a column based on a transformation. In this section, you will learn about these two types, their differences, and few other transformations that we have available in the add column tab of the Power Query Editor through some examples.

Add Column vs. Transform?
Add Column with a Transformation
Index Column: Row Number
Conditional Column
Add Column by Example; When you don’t know which transformation to use
Add Custom Column: Generic

2.13: Functions and Parameters; Dynamic Power Query

Power Query is a powerful tool for data transformation. This power can be amplified even more if you can make your queries dynamic. Instead of repeating several steps for similar data sources, you can create a function from those steps, and run that function for all other sources. Functions get parameters as the input. Functions and parameters can make everything in Power Query dynamic. If you want to learn Power Query advanced deep dive, this is the section to go through.

Defining Parameters
Using Parameters in an existing query
Advanced GUI for parameters
Creating Function from a query
Invoking the sample function
Add Column Transform: Invoke Custom Function
When the advanced GUI does not exist

2.14: Power Query Formula Language: M

The heart of Power Query is a scripting language named Power Query Formula Language or M. If you want to be a good data wrangler or data developer with Power Query, you must learn M scripting. The good news is that M scripting is not a hard language to learn. This section goes through the basics of the language, data types, literals, and everything is needed for understanding an M script’s structure.

What is M? and the importance of learning M
M Syntax
End of the line
Variable Names
Special Characters
Escape Character
Step by Step Coding
Literals
Function Call
Comments
A real-world example

2.15: Working with Data Structures in M

As you are dealing with data in Power Query, it is important to learn how to work with table, list, and record from the code. In this section, you will learn about these three structures in code, and how to navigate between different parts of each structure.

Primitive Value
List
Record
Table
Function
Navigating through List and List functions
Navigating through Record and Record functions
Navigating through Table and table functions
Concatenating lists and records

2.16: Advanced M Scripting

Now that you know more about M scripting, it is time to see how powerful this part of Power Query can be compared to the graphical interface of query editor. In this section, you will learn features that you have access to apply using M scripting. You will learn ways to get a list of all functions, doing error handling in an advanced way. Applying some changes in functions and parameters which is only possible through the code. You will also learn an end-to-end example using everything you learn about M at the end.

#Shared Keyword; function library of Power Query
Parameters in the code
Custom Functions through scripting
Error Handling in Power Query
Generators in Power Query: Implementing Loop Structure
EACH: singleton function
Sample Custom Function: Day Number of Year Custom Function

2.17: Performance Tips and Tricks for Power Query

Some transformations or operations needs careful attention in Power Query. In this section, you will learn about performance tips and trick for Power Query to make sure you have always a well performance tuned data transformation logic. Each sample will be discussed through the live demo in this section.

Enable Load; Simple, but Efficient
Reducing Number of Columns
Query Folding
Grouping and Aggregation; Performance Consideration
Merge; Before and After, things to Consider

2.18: Error Handling

In any data related solution, you should expect bad data rows to appear. If you haven’t thought about the appearance of bad data rows and you just did the transformations considering everything will be nice and tidy, then you may face many errors in Power Query. This section is all about how to handle errors, deal with bad data rows, create troubleshooting reports, etc.

Keep/Remove Errors; Troubleshooting report
Count Rows
Reference/Duplicate
Replace Errors
Data Type considerations

2.19: Use Cases

At the end of the training, we go through some end-to-end solutions using Power Query. These solutions leverage everything you learned through the training about this tool and language; you will see how all those parts come to help together to build the solution. We will go through building a date dimension which has all calendar columns, fiscal columns, and public holidays fetched live, and we will talk about combining files from a folder.

Date Dimension with Power Query; building the base table
Adding Fiscal columns to the Date dimension
Getting public holidays live and merging to the date dimension
Looping through files in a folder with Power Query

Register Here

Why Power BI Training?

Power BI is the newest Microsoft BI tool for data mash up, build modeling, and visualize it effectively. It supports mobile devices, it supports 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 the myths in following. Please note that these are Myths, and they are not the 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 seemed many BI enterprise solutions based on Power BI within very large organizations.

Myth 2: Power BI is easy to use, and doesn’t require a 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 a 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 the 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 the replacement of many other expensive BI tools in the market. We’ve been through scenarios of successful Power BI solutions that have been a 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 is always the 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.

In-Person Training;

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

https://radacad.com/events

Online Training;

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

https://radacad.com/events

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

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!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Register Here

Cancellation:
Cancellation up to 5 weeks before the event: full 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 the event): 25% of the standard price of the event to transfer

Transfer fee to another event date* (from 2 weeks to 1 day before the 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

Time

24 (Tuesday) 9:00 am - 25 (Wednesday) 4:30 pm GMT

Location

Auckland TBD

Auckland, Auckland, New Zealand

Organizer

Reza Radreza@radacad.com

Learn More

Brisbane TBD Brisbane, Queensland, Australia

1oct - 2oct 18:00 amoct 2RADACAD Power BI and AI Summit 2019 - Brisbane, Australia

Event Details

A compendious training of Power

Event Details

A compendious training of Power BI and AI from Rookie to Rock Star by RADACAD

The most up-to-date content
Selected hand-picked content from our 10+ day’s training agenda
The best content from our most popular training sessions
Detailed enough as a training
Broad enough to cover every major subject
Quick enough to give you the most value of your time
Instructed by Reza and Leila themselves in-person
Technical and effective with many live demos
Networking and Fun
Description

A compendious training of Power BI and AI from Rookie to Rock Star by RADACAD
- The most up-to-date content
- Selected hand-picked content from our 10+ day’s training agenda
- The best content from our most popular training sessions
- Detailed enough as a training
- Broad enough to cover every major subject
- Quick enough to give you the most value of your time
- Instructed by Reza and Leila themselves in-person
- Technical and effective with many live demos
- Networking and Fun
This is a training course developed from the most popular and up-to-date content of our training on Power BI and AI from Rookie to Rock Star. The content is short but explained clearly to get to the point. Many live demos will be presented by Leila and Reza in-person. Although this is a training, we expect many people to attend at this session, so you can consider this training like a mini-conference as well, where you have the opportunity to meet your peers in other companies, have networking and fun in addition to the all invaluable learnings.

We still offer our Detailed training sessions to organizations, but for many people, dedicating 10+ days of their time for Power BI training at once is not possible, so we have created this Summit, to help you learn the best of the best with pointers to study and read more. This is not a lecture-only presentation, you will experience live demos for every subject. With spending only a few days of your time, you get to learn the best of the best, and also connect with others.

Schedule:

Day 1

9:00 am – 12:30 pm – Sessions

12:30 pm – 1:30 pm – Lunch and Networking

1:30 pm – 5:00 pm – Sessions

5:00 pm – 7:00 pm – Networking Drink and Food

Day 2

9:00 am – 12:30 pm – Sessions

12:30 pm – 1:30 pm – Lunch and Networking

1:30 pm – 5:00 pm – Sessions

Content High-level Agenda:
- Get Data and Transform (Power Query)
- Data Modeling
- DAX and Calculations
- Visualization
- AI Visuals in Power BI
- AI in Microsoft Cloud
- AI in Power Platform
- AI in Dataflow
- Architecture, Administration, and Service
Detailed Agenda:

The agenda of the training session is selected hand-picked content by Reza and Leila from our full training contents below
- Power BI Detailed Agenda
- AI Detailed Agenda
Instructors

Reza Rad

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.

His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.

He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and user groups. And He is a Microsoft Certified Trainer.

Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leila Etaati

Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft Ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

She worked in Industries including banking financial, power and utility, manufacturing … She is a lecturer and trainer in Business intelligence and database design course at the University of Auckland.

Leila speaks in international SQL Server and BI conferences such as Microsoft Ignite, PASS Summit, PASS Business Analytics, PASS Rally, and many SQL Saturdays in USA, Europe, Australia, and New Zealand on Machine Learning and Analytics topics.

Pricing

Price is in USD.

Group Rate: three or more from the same company contact us for the special discount: training@radacad.com

Payment accepted online through PayPal or major credit cards.

We can also provide invoice and accept payment through the bank.

Who this Summit is for

All levels of working with Power BI and AI: Architects, Developers, Business Analysts, Data Scientist, Data Professionals… Here are some samples:

Attended Training Before: James attended Power BI training two years ago, but he wants to get information about recent updates and changes happen during these years.

Self-Learners: Sarah is self-learner in Power BI and AI, she learned everything via books, blogs, and videos. However, she feels behind the new updates and fast-growing tools and features, so she needs to find a way to refresh her information.

First Timer: Jane is new to Power BI and AI, she wants to know about the exciting features in these areas. She also interested to know how these features can help her to grow in her career.

Takeaways
- All updates and new features coming during the last 12 months
- All the materials for sessions
- Certification of completion
What others said about presenters and their training content

The workshop run by Reza and Leila was amongst the best I’ve ever done. The pace was just right. Their prepared materials were superb. I really enjoyed the hands-on nature of their training. I learned so much in a short time. I came back to my desk and felt confident enough to start building my own reports.

I would definitely sign up for their training again!

Donna MacKenzie Senior Revenue Analyst Massey University

I have been using Power BI for around 1 year and I was in love with it the very first day. It was very easy to visualize and bring our data stories to the client’s presentations. During my initial days, I had to use web search or use the Microsoft Power BI forums to find answers to my questions and to explore the tool. On many such occasions, I found Reza’s blog and articles to my rescue. I finally decided to attend the 5 day Power BI: Rookie to Rockstar Course.

Right from Day 1 through Day 5, Reza was a professional and a pleasant instructor. He is very approachable and very much flexible even though I was attending the Online Course from the United States. The classroom was LIVE from New Zealand. Very thorough in covering all the details mentioned in the curriculum and there was no question that he could not answer. His expertise and knowledge are second to none. I have learned a lot with the sessions especially data modeling and DAX functions which I would definitely put to use in the near future at my current job. I would like to thank Reza and his team for the flawless and wonderful sessions. It was very informative.

Abhi Guruprasad

I attended RADACADs “Power BI from Rookie to Rock – Star” course in Auckland from 19-12 Nov 2018. I had a beginner’s knowledge of Power BI and found the course extremely helpful in understanding what could be done within Power BI. Reza was an excellent instructor and explained concepts and methods in a clear and concise manner. There were lots of practical examples and exercises provided as part of the course, and Reza was also very helpful and willing to answer any questions we had about improving our existing Power BI reports and dashboards. A very enjoyable course – I highly recommended it.

Jamie Yim – Senior Business Analyst Enterprise Process

Together with two colleagues of mine, I joined Module 2 & 3 of the “Power BI from Rookie to Rock – Star” Training in Duisburg, Germany. The in-person training hold by Reza was just fantastic. In a well-structured way, Reza not only gave a comprehensive overview but also deep-dived into the functionalities of PowerBI and showed us the great value this software could bring to enterprises. I can strongly recommend the sessions and hope to get the chance to attend other courses as well. Thanks a lot to Reza and team!

Stefan Küppers Business Process Owner BI / SCI, Logistics – HAVI Logistics Business Services GmbH

We organized a 4-day training event with Reza and Leila from Radacad.

From the outset, they provided great advice on what they could cover and provided a very comprehensive overview for the 25 trainees attending the training. For anyone who is considering PowerBI specifically and want clarity on the best architecture and how to effectively use PowerBI, I strongly recommend contacting Radacad. They gave us a real head start.

Thanks, Reza and Leila.

Brent Gamble Team leader BI Training and Support – Massey University

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.

Kenny McMillan, Sports Physiologist / Data Analyst, Frankfurt, Germany

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.

Martin Catherall (Microsoft Data Platform MVP) and Consultant

Time

1 (Tuesday) 8:00 am - 2 (Wednesday) 5:00 pm

Location

Brisbane TBD

Brisbane, Queensland, Australia

Organizer

Reza Radreza@radacad.com

Learn More

Saint Paul College 235 Marshall Avenue Saint Paul, MN 55102 United States

11oct9:00 am- 5:00 pmSQL Saturday Pre-Con: Power BI from Rookie to Rock Star - All About DATA - Minnesota, USA

Event Details

Register Here

Speaker: Reza Rad

Duration: 480 minutes

Level: Intermediate

Track: BI Platform Architecture, Development & Administration

In this one day workshop, you will learn Power BI modeling and data preparation 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 using Power Query and the formula language (M) for data preparation and transformation. You will also learn about relationships, and modeling in Power BI, and DAX which is the calculation engine for Power BI. This course is full of live demos of real-world challenges of data modeling and how to solve it using Power BI. Modules include, but not limited to: Module 1: Data preparation using Power Query Module 2: Advanced Data transformations Module 3: M: Power Query formula language Module 4: Data Modelling in Power BI, Everything you need to know about Relationships Module 5: DAX and Calculations in Power BI This is a data modeling module of the world-famous Power BI training from Rookie to Rock Star by the book author; Reza Rad.

Time

(Friday) 9:00 am - 5:00 pm

Location

Saint Paul College

235 Marshall Avenue Saint Paul, MN 55102 United States

Learn More

Saint Paul College 235 Marshall Avenue Saint Paul, MN 55102 United States

11oct9:00 am- 5:00 pmSQL Saturday Pre-Con: AI with Power Platform: The realm of Impossible - Minnesota, USA

Event Details

Register Here

Speaker: Leila Etaati

Duration: 480 minutes

Level: Intermediate

Track: Analytics and Visualization

There is a huge need to use AI and ML in Power Platform to get more insight from data, create smart applications and so forth. In a one day workshop, the process of using AI and ML in Power BI desktop and Power BI Service using Cognitive services, Azure ML Studio, AutoML will be discussed. Next, AUdience will learn how to use AI and ML inside Power Apps and Microsoft Flow to access more insight from the data they have and to create smart applications. In general, new features and tools in Microsoft Machine learning in Power BI, Microsoft Power Apps, and Flow will be shown. Some parts of this workshop are hands-on.

Time

(Friday) 9:00 am - 5:00 pm

Location

Saint Paul College

235 Marshall Avenue Saint Paul, MN 55102 United States

Learn More

Orlando USA

14oct8:00 am- 5:00 pmOrlando Summit Pre-Con: AI in Power Platform, an Impossible Realm - Orlando, USA

Event Details

Register Here

Cognitive service:

In this module, how we able to consume Pre-Built AI in Power BI as a business user or developer will be discussed. The audiences get familiar with cognitive service tools in general, and how to consume it in Power BI desktop as a developer or in Power BI service as a business user.

Azure ML Studio and Services:

The learner will see how to create a simple ML model in Azure ML Studio or services and then consume its web service in Power BI desktop as a developer or as a Business user in Power BI services. The audience learns how they able to consume the model that has been created by a data scientist and put in Azure ML Service and Studio and apply on their datasets.

Visualization and Embed AI in Power BI

Learners get familiar with some visuals in Power BI that provide more insight over data such as Key Influencer and Correlation chart. Also, some of the other features in Power BI that use AI such as QnA and enter by example and so forth will be shown. Also, the audience will learn how to use some simple R codes to export data from Power BI

Module 2: AI Application with Power Apps and Microsoft Flow

Microsoft Power Apps and Flow make the creating application easier. The audience can consume the cognitive service to create some more smart applications like creating OCR, creating face recognition application, image detection and so forth.

Get Familiar with Power Apps and Flow

The audience will get familiar with the main concepts of Power BI and Flow and how they are working separately or together

Create an OCR application

The audience will learn how to create an OCR application with cognitive service, Power Apps and Flow.

Call any Cognitive Service API in MS Flow

Moreover, the audience will get familiar with how to call other cognitive services API like face API or Image tag API in Microsoft Flow in general. And create an Application

Audience:

This workshop can be useful for business users who do not want to write python or R scripts for machine learning and still able to consume and get the advantage of AI in their reports and Power apps applications. Also, they are able to see some embed AI in Power BI to get more insight out of data.
It will benefit developers who want to access created models in Azure ML Studio and service and want to write simple R/Python codes to export data or doing regular expressions.
This workshop is also good for a data scientist to see how they are able to communicate with their data engineer and business users who use Power BI desktop, Power Apps and Microsoft Flow.

Instructor

Leila Etaati, MVP

Consultant
RADACAD

Time

(Monday) 8:00 am - 5:00 pm

Location

Orlando USA

Learn More

15oct8:00 am- 5:00 pmOrlando Summit Pre-Con: Definitive Power BI Architecture - Orlando, USA

Event Details

Register Here

Pre-Conference Full Day Workshop

This training is designed for data architect or administrator, who is designing the architecture of leveraging Power BI in a solution. Someone who wants to understand how all components of Power BI are sitting beside each other to build the whole solution. This training is designed for understanding the strategy of using Power BI rather than the development of it.
In this training, you will learn about architecting the strategy of a Power BI solution from end to end. This is not training about development (Modules 1 to 3 already covered that). You do not need to attend previous modules to attend this course. This course is designed separately from those. However, knowing some of the basics of Power BI is helpful.

You will learn about Power BI Service, and different types of connections in Power BI and choose the right type of connection for your solution. You will also learn all different ways of sharing a Power BI Solution and the pros and cons of each. The course continues with a detailed discussion about row-level security. You will learn how gateway configuration and set up will be in the whole package. You will also learn about integrating Power BI with other tools, and some architecture blueprints to follow when you are designing a Power BI solution.

At the end of this training, you will be able to design the architecture of Power BI for your requirement; you can choose the right way of sharing and design the gateway configuration as well as the communication of Power BI with other tools and services. You will be able to answer any questions that come to your mind about a solution architecture in Power BI world and make the right decision to choose the right strategy of Power BI usage in your organization.

The training includes but is not limited to the topics below:

1: Power BI Service
Power BI service or website plays an important role in designing a Power BI solution. Power BI website is the hosting environment for Power BI reports, dashboards and datasets. In this section, you will learn about these objects and their configuration. You will also learn about the different types of connections in Power BI, and the position of the gateway in the solution, configuring and installing it.
• Power BI Components
• Power BI Service Content; Dashboard, Report, and Dataset
• Dashboard Features in the service
• What is Gateway?
• Two types of Gateway; On-premises, Personal
• Configuration and Installation of Gateway
• Import Data and Schedule Refresh
• DirectQuery Connection
• Live Connection
• Composite Model

2: Sharing
There are several ways of sharing Power BI reports and dashboards. Each of the methods has pros and cons and should be used in specific scenarios. In this section, you will learn scenarios to use each of these methods for sharing, and the sharing of architecture, and a comparison between all these methods at the end.
• Basic Dashboard or Report Sharing
• Workspaces in Power BI; Dev Environment
• Power BI Apps; User Environment
• Publish to Web
• Embed in SharePoint Online; Office 365 Integrated Sharing
• Power BI Embedded; Embedding content into another application
• Comparison of all Sharing methods

3: Security
Sharing is about giving users access to the entire content; security is about giving them access to part of it. There are different ways of implementing security (which is called row-level security in Power BI). Statics row-level security is a good option when roles are limited items. The next level is to define a dynamic row-level security using DAX functions. Dynamic row-level security comes as different patterns which will be discussed here through examples.
• Row Level Security
• Dynamic Row Level Security
• Patterns for Dynamic Row Level Security
• Manager Level Access
• Organization Chart Access as Dynamic Row Level Security
• Profiles and Users; Dynamic Row Level Security
• Dynamic Row Level Security using SQL Server Analysis Service Live Connection

4: Administration and Licensing
As a Power BI administrator, you need to have a careful eye on some of the metrics, and control some of the settings across your organization Power BI tenant. In this section, you will learn about Power BI administrator configuration options and options which are critical to controlling. You will also learn about all licensing options for Power BI and will have a clear view of what would be the best licensing option for you.
• Power BI Administrator Configuration
• Usage Metrics
• Customizing Usage Metrics
• Power BI Licensing Guide
• Power BI Premium
• Power BI Embedded Licensing

5: Integration
Power BI can integrate with other tools and services such as Reporting Services and Excel. In this section, you will learn about all integration options for Power BI. This section will also give you a full understanding of Power BI Report Server; the on-premises usage of Power BI. You will learn Power BI REST API capabilities (not at a developer level, more in architecture level), and you will learn about real-time streaming options available with Power BI.
• PowerPoint Integration with Power BI
• Power BI and Excel; More than just an Integration
• Power BI Report Server: Power BI on-premises
• SQL Server Reporting Services Integration with Power BI
• Real-time Streaming with Power BI, and Azure Stream Analytics
• Power BI REST API

6: Architecture
The last part of the training focuses on architecture blueprints for Power BI. In addition to architecture best practices for sharing, self-service, enterprise-level architecture, you will learn about a tool that can help in Power BI solution designed by RADACAD; Power BI Helper.
• Architecture for Enterprise Scale
• Architecture for Sharing
• Architecture for Self-Service
• A tool that helps: Power BI Helper

Instructor

Reza Rad, Microsoft Regional Director, MVP

Consultant, Trainer
RADACAD

Time

(Tuesday) 8:00 am - 5:00 pm

Learn More

Microsoft Avalon 8000 Avalon Boulevard #Suite 900 Alpharetta, GA 30009 United States

18oct9:00 am- 5:00 pmAI in Power Platform Pre-Con: The Realm of the Impossible - Atlanta, USA

Event Details

Description: Using

Event Details

Description:

Using AI is a norm this day in developing applications and analyzing the data. Easy AI is not a dream anymore, that means everyone regardless of how they are familiar with AI and ML concepts can use AI in their applications and analysis.

Besides, Power Platform technologies (Power BI, Power Apps and Flow) have been used by analysts, BI developers, office 365 specialists and users and so forth for a while. In a one day workshop, audiences will learn how to leverage AI in Power Platform.

Module 1: Introduction to AI and ML

The audience will get familiar with AI and ML concepts and what architecture and opportunity they have. Some introduction to ML approaches from predictive, descriptive and prescriptive analytics will be provided. The audience also gets familiar with prebuild and Custom AI tools in Microsoft stacks such as cognitive service and Azure Ml Service.

Module 2:

Next an introduction to Power BI desktop and service especially Data flow will be provided. The audience will see different approaches to use AI and ML inside Power desktop and Power BI service. In Data flow how we able to use AutoML, and AI insight will be shown. Also, the audience will see how to consume their models that have been created in Azure ML Services using Python, AutoML interface, or Azure ML Studio inside Power bI desktop or Data flow. Also, they will get familiar with some of the interesting visuals like Key Influencer to analyze their data better.

Module 3:

In this module, the audience will learn about how to do AI in Power Apps and Microsoft Flow using AI builder for the aim of classification, regression, and forecasting. Also, they will learn how they can create an application for the aim of object detection and form processing using AI builder. Next audience will see how to consume the other cognitive service model in Microsoft Flow such as an image tag or face recognition.

About the Speaker:

Leila is First Microsoft AI MVP in New Zealand and Australia; She has a Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members; She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now), Difinity (2017 till now) and Global AI Bootcamp 2-18. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft Ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. Leila is an active Technical Microsoft AI blogger for RADACAD.

Dr. Leila Etaati

Time

(Friday) 9:00 am - 5:00 pm

Location

Microsoft Avalon

8000 Avalon Boulevard #Suite 900 Alpharetta, GA 30009 United States

Learn More

Online

24oct - 25oct 249:00 amoct 25Power BI from Rookie to Rock Star – Module 1: Power BI for Data Analysts (Essentials and Visualization) – 2 days course - Online, US Central Timezone

Event Details

Register Here

Course Title: Power BI from Rookie to Rock Star

Length:

From 1 to 9 days (Lecture + Labs): depends on the modules you enrol.

Delivery method:

In-Person or Online: Check the schedule of upcoming courses.

Type of training:

Public or private (contact us for more details)

This course is delivered to thousands of people all around the world, check out only a few of the recommendations at the bottom of this page, and check some of our clients.

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (2 days)
Module 2: Power BI for Data Wrangler and Transformer (2 days)
Module 3: Power BI for Data Modeler (2 days)
Module 4: Power BI for Architects (1 day)
Module 5: Power BI for Data Scientists (2 days)

Module 1: Power BI for Data Analysts (Visualization) – 2 days course

This training is designed for data analysts, who have the data modeled and ready for them to visualize. In this training, you will learn detailed visualization practices of Power BI.

In this two days training, you will learn all components of Power BI needed for building Power BI reports and dashboards. You will learn about components such as Get Data (Power Query), Modelling and DAX, and Visualization. You will also learn about the Power BI service (website), and components that are needed to share your reports with others.

The training continues with more focus on Visualization components such as different types of charts and visuals and scenario to use them. You will also learn about advanced visualization techniques such as designing mobile reports, changing the interactivity of visual, detailed learning of slicers and filters, creating parent-child reports, etc.

At the end of this training, you will be able to do all visualization requirements for Power BI and will understand all other components of Power BI and how these are all working together.

The training includes but not limited to topics below:

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 the basics of this product and introduce all components of Power BI (Power Query, Power Pivot, Power View, 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, and Power Q&A.

1.2: Getting Data and Transformation

Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on the cloud. In this section, you will learn how the Get data experience in Power BI is and how you can transform the data in a way to get it ready for modeling.

What is Power Query: Introduction to Data Mash-Up Engine of Power BI
Different versions of Power Query
Power Query Introduction
Query Editor
Transformation GUI
Get Started with Power Query: Movies Data Mash-Up
Power BI Get Data from Excel: Everything You Need to Know
What is the Role of Power Query in a Power BI Solution

1.3: Data Modelling and DAX

Data Modelling in Power BI is an in-memory-based technology. You will learn about the structure of modeling in Power BI, and you will learn the importance of relationships and their direction. You will also learn about calculations in Power BI and how to write them. DAX is Data Analytical eXpression language. DAX has a similar structure to excel functions, but it is different. In this module, you will learn DAX about DAX too.

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

Power BI xVelocity engine basics and concepts
Relationships in Power BI
Hierarchies and Formatting
Sorting by other columns
Date Table
Introduction to DAX
Calculated Columns, Measures, and Calculated Tables

1.4: Data Visualization

Data Visualization is the front end of any BI application; this is the user viewpoint of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data. In this module, you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power BI visualization skills. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with Power BI Desktop.

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

Power BI Desktop Visualization
Formatting Visuals in Power BI Desktop
Basic Charts and Visuals in Power BI
Sorting, Filtering, and categorization
Custom Visuals in Power BI Desktop
Maps and Geo-Spatial Visualization

1.5: Power BI Service

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 on 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;

Basic Sharing and using workspaces in Power BI web site
Dashboard vs. Report
Power Q&A
Mobile Dashboard Design
Row Level Security
Schedule Refresh vs. Other types of connections
Gateway’s Role in the Service

1.6: Visualization Basics

Visualization is an important part of any BI system. In Power BI, Visualization plays a critical part. In this section, you will learn about why visualization is important, with few basics of visualizations such as comparing stacked vs. clustered chart. You will also learn in this section about data exploration techniques such as drill down/up, using pages, etc.

Importance of Visualization
Basic Charts; Bar and Column Charts
Clustered vs. Stacked Charts
Q&A for Reports
Quick Measures in Power BI
Drill Down and Up using visuals and hierarchies
Pages

1.7: Slicing and Dicing

The importance of slicing and dicing data in Power BI is critical. Power BI is not a visualization tool only, but it is also a data exploration tool. There are several ways you can filter the data. In this section, you will learn the difference between filters and slicers. You also learn about different scopes of filtering, as well as filtering modes. For slicers, you will learn different types of slicers and some advanced features such as syncing slicers through different pages.

Filters
Scopes of Filters: Visual Level, Page Level, Report Level
Modes of Filtering: Basic, Advanced, Relative, Top N
Drill through Page Filter: Creating master-details page scenario in Power BI
Slicers
Types of Slicers; Date, Text, Number
Slicer Formatting
Syncing Slicer between Pages

1.8: Advanced Visualization in Power BI

Know that you know about visualizations and slicing and dicing, it is a good time to talk about some advanced techniques which will take your visualizations to the next level in Power BI. You will learn about techniques such as changing the interaction of visuals, report page tooltips, Bookmarks and dynamic visualizations in this section.

Report Page Tooltip
Controlling the interaction of Visuals in a page
Designing Power BI reports for Mobile
Grouping and Binning
Bookmark; saving the state of a page
Buttons; action items
Selection pane; visibility control in Power BI
Golden triangle; Bookmark, button, and selection pane
Colour theme or pallets in Power BI

1.9: Best Practice Scenarios of Using Visuals

It is a good time to learn about all built-in visuals in Power BI now. It is important to know which visual should be used in what scenario. You will also learn in this section about the pros and cons of each visual. You will learn specific features of the visual that can help to solve real-world scenarios. All the examples will be hands-on.

Line Chart; Trend Analysis
Combo Charts; Different Scales in one graph
Ribbon Chart; Ranking
Waterfall Chart; Cashflow
Scatter Chart; Storytelling with the data
Grouping charts: Pie, Donut chart, and Treemap charts
KPI visual
Gauge
Card Visual
Table and Matrix; showing the numbers with conditional formatting

1.10: Geo Location Visualization: Map Visuals

In Power BI, there are multiple ways of visualizing items on the map. In this section, you will learn about all the built-in ways of using map visuals in Power BI, the pros, and cons of each method and special considerations for some of the visuals.

Map Visual; Using Bing to find spots
Fine Tuning Address Details
Map Visual; Using Latitude and Longitude
Filled Map; Regions and Polygons
Data Category importance for the filled map
Shape Map; Having custom map visual
ArcGIS Map; Map visual which can do everything

1.11: Custom Visuals

In addition to the built-in list of Power BI visuals, you can leverage some of the third party visuals created by other companies called Custom Visuals. Creating custom visuals is a developer topic, which we won’t discuss in this training, but you will learn about how to use custom visuals. You will learn about the most useful custom visuals in Power BI through many demos.

Adding and using a custom visual
Infographic Designer
Tachometer Gauge
Map custom visuals
Certified custom visuals
Hierarchy Slicer
Play Axis
R Custom Visuals

Why Power BI Training?

Common Myths about Power BI

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

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

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

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

In addition, there is always the 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.

In-Person Training;

https://radacad.com/events

Online Training;

https://radacad.com/events

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

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!

R. Kemp, Canada

The course was an excellent investment overall, it exceed my expectations. It was well paced and presented. The instructor, Reza Rad, was excellent and was able to answer all my questions and explain complex idea in a manner that was easy to understand and follow. I had been using Power BI Desktop for a number of months prior to taking this course, but wish I had attended it sooner! The course structure of 1 day of overall Power BI and followed by 4 days of more intensive instruction on the various parts of Power BI allowed for a basic understanding of the whole, and then more comprehensive learning. The live-on-line experience worked well technically and allowed for questions and problem-solving with the instructor. I learned a lot about Power BI and this course gave me a great foundation for using Power BI to clean, model, design, and share reports using a variety of visualizations that will provide business intelligence to my company. I would recommend this course to anyone wanting to learn Power BI either as a starting point or even after you have used the tool to deepen your understanding and build your skill-set.

Who Attended RADACAD Training Courses

Cancellation:
Cancellation up to 5 weeks before the event: full 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

Transfer fee to another event date* (from 2 weeks to 1 day before the 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.

Instructors

Reza Rad

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.

His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.

He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and user groups. And He is a Microsoft Certified Trainer.

Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leila Etaati

Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft Ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

She worked in Industries including banking financial, power and utility, manufacturing … She is a lecturer and trainer in Business intelligence and database design course at the University of Auckland.

Leila speaks in international SQL Server and BI conferences such as Microsoft Ignite, PASS Summit, PASS Business Analytics, PASS Rally, and many SQL Saturdays in USA, Europe, Australia, and New Zealand on Machine Learning and Analytics topics.

Pricing

Price is in USD.

Group Rate: three or more from the same company contact us for the special discount: training@radacad.com

Payment accepted online through PayPal or major credit cards.

We can also provide invoice and accept payment through the bank.

Time

24 (Thursday) 9:00 am - 25 (Friday) 5:00 pm

Organizer

Reza Radreza@radacad.com

Learn More

Washington State Convention Center 705 Pike St., Seattle, WA 98101

5nov9:00 am- 5:00 amPass Summit Pre Con- AI and Power BI: The Realm of the Impossible - Seattle, USA

Event Details

Register Here

AI and Power BI: The Realm of the Impossible

Speaker: Leila Etaati

Duration: Full Day

Level: 200

Stream: Analytics

Audience: Analyst, BI/Analytics Practitioner

Technology Focus: Advanced Analytics

Track: Analyze

There are tons of ways to do machine learning in Power BI. From using Pre-built AI services such as Cognitive services and custom visuals, to Custom AI tools such as writing R, Python scripts, or using Azure ML Studio (a drag and drop service). In this one-day workshop, first, an overview of what is machine learning and different approaches to machine learning (Predictive, descriptive and prescriptive analytics) and AI will be presented. The audience will learn the main process of doing machine learning by writing simple R or Python scripts to do predictive analytics in Power Query. In the next step, they will see how they able to consume some of the exciting custom visual in Power BI for the aim of machine learning without writing any lines of codes (such as decision tree, key influencer and so forth) and how to use them to add more analytics perspective to their reports. Moreover, the process of creating advanced analytics visual with the help of writing R or Python code will be explained. Next, the audience will see how to create a simple Azure Machine Learning model web service and then apply it on collected data in Power BI desktop (Power Query) for predictive analytics in Power BI desktop and data flow (Power BI Service). Next, the audience will learn how to use pre-built AI such as cognitive service inside Power BI desktop (Power Query) and Power BI service (Data Flow).

Time

(Tuesday) 9:00 am - 5:00 am GMT

Location

Washington State Convention Center

705 Pike St., Seattle, WA 98101

Organizer

Leila Etaatileila@radacad.com

Learn More

Cordis Hotel Auckland Auckland

17feb - 20feb 178:00 amfeb 20Difinity Conference (Microsoft Data Platform Conference) 2020 - Auckland, New Zealand

Event Details

Register Here

What is Difinity?

Difinity is the largest Microsoft Data Platform, Business Intelligence, AI, and Analytics Conference in New Zealand. IT Decision Makers, Developers, Analysts, IT Professionals, Database Administrators, Architects, and Consultants will gather for three consecutive days of learning.

Details: http://difinity.co.nz

4 Days Conference

Difinity is a 4 days conference. The first day is full day workshop and the next 2 days we have 40+ sessions and the 4th day will be a post conference workshop day.

Who will Speak

We have 40+ Speakers; 10+ Microsoft speakers, 20+ Microsoft data platform MVPs, MCMs MCA from US, UK, Australia, Asia, Europe, and New Zealand.

Pre-Conference (17th Feb) and Post-Conference (20th Feb) Venue will be Cliftons Auckland and the main conference (18th and 19th Feb) will be held at the Cordis Hotel Auckland
To view where your pre-con will be held please refer to this page http://difinity.co.nz/

Full-day Pre-Conference Workshops 17th Feb 2020

Uwe Ricken – Analysis of your SQL Server like a PRO

Sergei Gundorov – Power BI for Developers

Dejan Sarka – Data Science Algorithms

Ginger Grant – Getting Started with Data Science and Databricks Stefano Tempesta Design and develop blockchain applications in Azure

Stefano Tempesta – Design and develop blockchain applications in Azure

Reza Rad – Back to Basics: Power BI Modelling for Non-Data Professionals

Post-conference Full-day Workshops Thursday 20th Feb

Matt Allington – Demystifying DAX

Ken Puls – Master your data for Excel & Power BI

Vishwas Lele – Kubernetes on Azure

Sandy Winarko and Andy Leonard – Intelligent Data Integration with SSIS and Azure Data Factory

Gilbert Quevauvilliers Power BI Premium – What is it, how does it work and how can it help my organisation

Leila Etaati – AI in Power Platform: The Realm of the impossible

2-days conference sessions on 18th and 19th Feb 2020

We have 40+ sessions on the different subject of Microsoft Database Administration, Business Intelligence, and Data science presented by experts speakers in the Microsoft data platform field. check out the detail of these sessions from Here.

More details here: http://difinity.co.nz

Details of Sessions and Speakers

Here is a glance of topics for this conference (up to date list is available in Difinity website);

Power BI
Power Apps
Microsoft Flow
AI
Cognitive Services
Azure Machine Learning
Azure Data Bricks
Deep Learning
R and Python
SQL Server Administration
SQL Server Development
Performance Tuning
DAX
Power Query
Visualization
Power BI Architecture
Power BI Service
Gateway
SQL Server Analysis Services
SSIS
SSRS
Azure SQL Data Warehouse
Azure Data Factory
Azure Data Catalog
Azure SQL Database
Data Warehouse
Data Science
Predictive Analytics
Data flow
…

Please note: Recording of any type at Pre-Conference Workshops and Conference sessions is not permitted under any circumstance.

Registration for Difinity is open now;

http://difinity.co.nz

FAQs

Where can I contact the organizer with any questions?

Is my registration/ticket transferrable?

Yes, before starting the conference only.

Can I update my registration information?

Yes, before starting the conference only.

What is the refund policy?

Cancellation Details are listed below. Cancellation fees are calculated per ticket (pre-con and 2-days conference individually);

Cancellation: (Per Ticket)

Cancellation up to 5 weeks before the event: full 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.

No Show:

No fee will be refunded for no show.

Change: (Precon selection)

Changing the pre-con workshop is only possible until 10 days before the event. Any changes after that are subject to $200 Transfer fee plus GST per pre-con seat.

The name on the registration/ticket doesn’t match the attendee. Is that okay?

You need to change/transfer the ticket to someone else before starting the conference. On the day of the conference, the registration/ticket’s name should match the attendee’s name.

Difinity (RADACAD) may share my information with Microsoft so they may contact me about their products and services. Microsoft Online Privacy Statement

Difinity may share my information with RADACAD so they may contact me about their products and services. Microsoft Online Privacy Statement

Time

17 (Monday) 8:00 am - 20 (Thursday) 5:00 pm

Location

Cordis Hotel Auckland

Auckland

Learn More

Book Pro Power BI Architecture

Book: Power BI from Rookie to Rock Star

Power BI and AI Academy

Book: Power BI and R

Book: Azure Machine Learning Studio: An Unleashed Guide

Leila’s latest tweets

Tweets by leila_etaati

Reza’s latest tweets

Tweets by Rad_Reza

Event Details

Instructor

Time

Location

Event Details

Instructor

Time

Location

Event Details

Time

Location

Event Details

Course Title: Power BI from Rookie to Rock Star

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 2: Power BI for Data Wrangler/Transformer (Data Transformation) – 2 days course

Why Power BI Training?

Common Myths about Power BI

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

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

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

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

In-Person Training;

Online Training;

What others say about the training and trainer

Time

Location

Event Details

Description

A compendious training of Power BI and AI from Rookie to Rock Star by RADACAD

Schedule:

Content High-level Agenda:

Detailed Agenda:

Instructors

Reza Rad

Leila Etaati

Pricing

Who this Summit is for

Takeaways

What others said about presenters and their training content

Time

Location

Event Details

Time

Location

Event Details

Time

Location

Event Details

Instructor

Time

Location

Event Details

Instructor

Event Details

Time

Location

Event Details

Course Title: Power BI from Rookie to Rock Star

Instructor: Reza Rad

Power BI from Rookie to Rock Star

Module 1: Power BI for Data Analysts (Visualization) – 2 days course

Why Power BI Training?

Common Myths about Power BI

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

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

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

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

In-Person Training;

Online Training;

What others say about the training and trainer

Instructors

Reza Rad

Leila Etaati

Pricing

Event Details

AI and Power BI: The Realm of the Impossible

Time

Location

Event Details