2-Day Applied Power BI Workshop – Atlanta (Sep 11-12)
2018-09-11 08:30 - 2018-09-12 17:00 (America/New_York) | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Do you know that Power BI is a top 10 sought after skill? Are you looking for an agile self-service platform that doesn’t require reporting and query skills to get basic analytics done without reliance on IT? Or, perhaps you’ve heard or evaluating Power BI but not sure where to start or how to take the most out of it? If so, this workshop is for you. Prologika has helped many organizations of all sizes to adopt Power BI. Packed with features, Power BI supports a dizzying variety of features and integration scenarios and it offers plenty to all types of users interested in data analytics: information workers, data analysts, BI pros, and developers.
Reserve your seat today to attend this insightful 2-day workshop for only $999 when Teo Lachev (CEO of Prologika, Microsoft Data Platform MVP, and Power BI Red Carpet Partner) teaches you practical Power BI knowledge and data analytics skills that you can immediately apply to your job. See how Power BI can improve your usability and productivity even further.
Event Summary

Date: September 11 and 12
Time: 8:30 AM – 5 PM
Location: Microsoft Office in Alpharetta
Catering: lunch provided
Syllabus: available here
Price: $999 (use coupon POWERBI20180911 for an instant 5% discount if you sign up two or more attendees from your company)

Key Benefits

Understand how Power BI changed the way users (information workers, data analysts, BI pros, and developers) gain and share data insights.
Learn how to connect to popular cloud services to derive instant insights, create interactive reports and dashboards, and view them in the browser and on the go.
Discover how to integrate and shape data from virtually everywhere and then implement sophisticated self-service models and business calculations.
Learn how to share your BI artifacts and collaborate with other teammates.
Gain practical skills by creating a self-service model in the lab exercises.
Learn Power BI best practices, limitations (every tool has them) and workarounds.
Get your questions answered.
and much more…

You won’t want to miss this educational and engaging training event! Attend it and get a free paper copy of the book Applied Microsoft Power BI (3rd edition)! Please use the Tickets section at the bottom of this page to register today as seating is limited. Moreover, after course completion and by the end of the year, all course attendees will receive a free, one-hour, follow-up consultation with me on any Power BI related topic.
Audience

Information workers
Business analysts
BI professionals
In general, anyone interested in self-service data analytics with Power BI

Prerequisites
Students are encouraged to bring their own laptops for the exercises. Detail setup instructions and source files will be sent before the event.
Instructor
Teo Lachev is a consultant, author, and mentor specializing in Data Analytics. Teo helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower his clients to apply effectively data analytics in order to understand, improve, and transform their business. Teo has authored and coauthored several books and his latest one is “Applied Microsoft Power BI (3rd edition)” He has been leading the Atlanta Microsoft Business Intelligence and Power BI Group since he founded it in 2010. Microsoft has recognized Teo’s expertise and contributions to the technical community by awarding him the prestigious Microsoft Most Valuable Professional (MVP) for Data Platform award since 2004.
Cancellation Policy
You can cancel your registration within 15 (or more days) advance notice in writing before the class start date. If you request a refund, a $200 processing fee will be subtracted from the refund. No refunds will be given to registrants who cancel within 15 days of the class start date, or who don’t attend the class for whatever reason. You can always substitute other attendees for paid registrants at any time upon a written notice. If Prologika cancels the class for whatever reason, we’ll issue a full refund to all paid registrants. Besides the registration fee, Prologika will refund no other expenses, including travel expenses and hotel reservations.

10 Ways to Empower Your BI Strategy with Power BI
2018-09-20 16:30 - 19:00 | DAMA, Embassy Row 660, Suite 105,6600 Peachtree Dunwoody Rd, Atlanta, 30328, United States
Not sure what value Power BI can bring to your BI infrastructure? Join me to discuss 10 ways Power BI can help augment your existing or envisioned Power BI strategy. If you’re interested in the Power BI but you’re not sure how it fits within your organizational data strategy, this event is for you. Discussion points include:

Organizational BI
Self-service BI
Cloud vs. on-premises deployments
Predictive analytics
External reporting
Integrated solutions

Get your Power BI questions answered and see demos along the way.

Bridge Analytics and Developer Worlds with Power BI and PowerApps
2018-09-22 08:00 - 17:00 | SQL Saturday Alpharetta, 2875 Old Milton Pkwy, Alpharetta, GA, 30009, United States
One of the Power BI most prominent strengths is that it’s a part of the much broader Microsoft Data Platform that spans various on-premises and cloud offerings for data storage, processing, and analysis. Join me to learn how to integrate Power BI with PowerApps and discover exciting new possibilities that redefine the meaning of a report. During this entirely hands-on, no-slides session I’ll walk you through the steps to implement a popular report requirement for writeback, that Power BI doesn’t natively support.

Master Data Management
2018-09-25 06:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States

2-Day Applied DAX with Power BI Workshop – Atlanta (Oct 15-16)
2018-10-15 08:30 - 2018-10-16 17:00 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Struggling with DAX? Data Analysis Expressions (DAX) is the expression language of Power BI, Power Pivot, and Analysis Services Tabular. It’s very powerful but it’s usually perceived as complex and requiring a steep learning curve. Taught by an established expert, this two-day workshop is designed to help you become proficient with DAX. Think of this workshop as advanced Power BI training.
Reserve your seat today to attend this insightful 2-day workshop for only $999, when Teo Lachev (CEO of Prologika and Microsoft Data Platform MVP) teaches you the necessary DAX skills that you can immediately apply to your job.
Event Summary

Date: October 15 and 16
Time: 8:30 AM – 5 PM
Location: Microsoft Office in Alpharetta
Catering: lunch provided
Syllabus: available here
Price: $999 (use coupon SQL201810 for an instant 5% discount if you sign up two or more attendees from your company)

Key Benefits

Understand best practices for model design
Create advanced calculated columns
Master measures and evaluation contexts
Apply time intelligence
Work with advanced relationships and data security
Learn how to troubleshoot performance issues
Brainstorm your DAX puzzles
and much more…

You won’t want to miss this educational and engaging training event! Moreover, after course completion and by the end of the year, all course attendees will receive a free, one-hour, follow-up consultation with me on any Microsoft BI related topic. Please use the Tickets section at the bottom of this page to register today as seating is limited.
Audience

Data analysts working with Power BI or Power Pivot
BI Pros working with Power BI or Analysis Services Tabular
In general, anyone interested in learning DAX

Prerequisites
Students are encouraged to bring their own laptops for the exercises. Detail setup instructions and source files will be sent before the event.
Instructor
Teo Lachev is a consultant, author, and mentor specializing in Data Analytics. Teo helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower his clients to apply effectively data analytics in order to understand, improve, and transform their business. Teo has authored and coauthored several books and his latest one is “Applied Microsoft Power BI (3rd edition)” He has been leading the Atlanta Microsoft Business Intelligence and Power BI Group since he founded it in 2010. Microsoft has recognized Teo’s expertise and contributions to the technical community by awarding him the prestigious Microsoft Most Valuable Professional (MVP) for Data Platform award since 2004.
Cancellation Policy
You can cancel your registration within 15 (or more days) advance notice in writing before the class start date. If you request a refund, a $200 processing fee will be subtracted from the refund. No refunds will be given to registrants who cancel within 15 days of the class start date, or who don’t attend the class for whatever reason. You can always substitute other attendees for paid registrants at any time upon a written notice. If Prologika cancels the class for whatever reason, we’ll issue a full refund to all paid registrants. Besides the registration fee, Prologika will not refund any other expenses, such as travel expenses and hotel reservations.

Predictive Analytics with Power BI
2019-01-07 18:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Predictive Analytics with Power BI
Predictive analytics, also known as data mining, machine learning, and artificial intelligence (AI), is an increasingly popular requirement. Fortunately, you don’t have to be a data scientist to benefit from machine learning in Power BI. This session is organized in two parts:
· Part 1 – We will revisit the existing machine learning features in Power BI, including Quick Insights, Explain Increase/Decrease, linear forecasting, integration with R and Python.
· Part 2 – We will look at exciting new features that are coming up in near future, such as integration with Azure ML and Cognitive Services, and automated machine learning.

Azure Data Lake for First Time Swimmers
2019-02-04 18:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Data Lake may be the hot new way to store data for reporting, but it can be scary if you’ve never dealt with one. If you have no idea what a data lake is, have no fear! You will get an intro to the concept of data lake and what scenarios you should be considering it as your platform. From there you’ll get to see how Azure Data Lake Analytics and U-SQL allow developers and data professionals to create compelling analytics with data that previously was difficult to work with.

Using the Power Platform to Enhance Spatial Granularity
2019-05-06 18:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Join this session to see how you can use the Power Platform to solve a real world customer problem. With a growing mobile workforce, many organizations are trying to figure out how to properly arm them with the correct tools. In this session we will explain and demonstrate how you can leverage the Power BI Mobile app and Microsoft Flow to build a solution that enables them to quickly identify locations near and far. We will demonstrate how the solution was built step-by-step, detailing how and why certain technologies and solutions were selected or not.

What's New for BI in SQL Server 2019
2019-05-18 13:00 - 14:00 | SQL Saturday Alpharetta, 2875 Old Milton Pkwy, Alpharetta, GA, 30009, United States
SQL Server 2019 delivers important data analytics features and enhancements. Join this session to discover what BI features are coming up in Database Engine, SSIS, SSAS, SSRS (Power BI Report Server), and MDS, and to see some of these preview features in action.

Bridge Analytics and Developer Worlds with Power Platform
2019-06-03 18:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
One of the Power BI most prominent strengths is that it’s a part of the much broader Microsoft Power Platform and Data Platform that spans various on-premises and cloud offerings for data storage, processing, and analysis. Join this session to learn how to integrate Power BI with PowerApps and discover exciting new possibilities that redefine the meaning of a report and let you do more with less. During this entirely hands-on, almost no-slides session I’ll walk you through the steps to implement a popular report requirement for writeback, that Power BI doesn’t natively support.
Bridge Analytics and Developer Worlds with Power BI and Power Platform (Teo Lachev)

10 Ways to Empower Your BI Strategy with Power BI
2019-06-08 06:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Not sure what value Power BI can bring to your BI strategy? Join me to discuss 10 ways Power BI can help augment your existing or envisioned Power BI strategy. If you’re interested in Power BI but you’re not sure how it fits within your organizational data strategy, this event is for you. Discussion points include:

Organizational BI
Self-service BI
Cloud vs. on-premises deployments
Predictive analytics
External reporting
Integrated solutions

Get your Power BI questions answered and see demos along the way.
10 Ways to Empower Your BI Strategy with Power BI

SQL Atlanta BI Atlanta BI Edition
2019-10-19 12:30 - 13:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
SQL Saturday Atlanta (BI Edition) will be held on October 19th. I’ll present a “Power BI Pro, or Premium: that is the question” strategy-oriented session at 12:30.
“One question that always pops us during my Power BI assessments for companies planning to adopt Power BI is which SKU to buy. The choice might seem obvious to your organization, but there is much more below the surface. Join this session and learn important considerations that might influence your decision, including:

Licensing cost
Hosting organizational semantic layers
External reporting
Features
On-premises reporting”

Atlanta MS and Power BI Group Meeting
2020-02-03 18:30 - 20:30 | Microsoft Office Alpharetta, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA, 30009, United States
Aggregations in Power BI
Aggregations are one of the most important optimization methods for managing big datasets in Power BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database. In this session, you will learn about the concept of aggregations, different table storage modes in Power BI, different kinds of aggregation tables, how to configure aggregation tables so that they can answer high level user queries, and finally how to use tools such as DAX Studio or Extended Events to determine if the aggregations are actually being used.

Power Platform World Tour Precon
2020-02-10 09:00 - 17:00 | Atlanta Marriott Marquis, 265 Peachtree Center Ave NE, Atlanta, GA, 30303, United States
Organized by Microsoft and Dynamic Communities, the Power Platform World Tour will take a place in Atlanta from 2/10-2/12, 2020. I’m teaching Power BI Dashboard in a Day (DIAD) on Feb 10 for a full day. Although this is a paid event ($599), you should get a great business value as the audience will probably be smaller and I’ll be able to provide more personal attention.

Bridge Analytics and Developer Worlds with Power Platform
2020-02-12 10:15 - 11:15 | Atlanta Marriott Marquis, 265 Peachtree Center Ave NE, Atlanta, GA, 30303, United States
One of the Power BI most prominent strengths is that it’s a part of the much broader Microsoft Data Platform that spans various on-premises and cloud offerings for data storage, processing, and analysis. Join me to learn how to integrate Power BI with PowerApps and discover exciting new possibilities that redefine the meaning of a report and let you do more with less. During this entirely hands-on, almost no-slides session I’ll walk you through the steps to implement a popular report requirement for writeback, that Power BI doesn’t natively support.

Virtual Power BI Dashboard in a Day (DIAD) on April 14
2020-04-14 09:00 - 17:00 | Virtual Meeting
Are you looking for an agile self-service BI platform that doesn’t require reporting and query skills to get basic analytics done without reliance on IT? Partnering with Microsoft, Prologika is pleased to offer an 1-day instructor-led workshop covering the end-to-end self-service BI process with Power BI. Redesigned for digital delivery, this workshop will help you understand how to analyze your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.

Attend this insightful 1-day workshop from anywhere for only $199, when Teo Lachev (CEO of Prologika, a Power BI Red Carpet Partner) teaches you practical Power BI knowledge and data analytics skills that you can immediately apply to your job. See how Power BI can improve your usability and productivity even further.

Key Benefits
At the end of the day, you’ll learn how to:

Connect to, import, and transform data from a variety of sources
Define business rules and KPIs
Explore data with powerful visualization tools
Build stunning reports
Share their dashboards with their team and/or the world
Learn best practices and get your questions answered

Agenda
The workshop will be conducted online. Login instructions will be sent to registered attendees before the event. All times are Eastern Time zone (GMT-4).
Morning
09:00 AM –10:00 AM –Introduction to Power BI
10:00 AM –10:30 AM–Lab 1 Accessing & Preparing the data
10:30 AM –10:45 AM – Break
10:45 AM –11:15 AM –Lab 1 Solution + Questions
11:15 AM –11:45 AM –Lab 2 Data Modeling and Exploration
11:45 AM –12:30 PM –Lab 2 Solution + Questions
12:30 PM –01:00 PM –Break for lunch
Afternoon
01:00 PM –01:30 PM–Lab 3 Visualizations
01:30 PM –02:00 PM–Lab 3 Solution + Questions
02:00 PM –02:30 PM –Lab 4 Publishing and accessing Reports
02:30 PM –02:45 PM–Break
02:45 PM –03:15 PM–Lab 4 Solution + Questions
03:15 PM –03:45 PM–Lab 5 Building a Dashboard and Sharing
03:45 PM –04:15 PM–Lab 5 Solution + Questions
04:15 PM –05:00 PM–Q&A
Your Instructor
Through his Atlanta-based company Prologika (https://prologika.com), a Microsoft Gold Partner in Data Analytics, Teo Lachev helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Microsoft has awarded Teo the Most Valued Professional (MVP) – Data Platform award every year since 2004 for his expertise and contributions to the community.

Cancellation Policy
Tickets are not refundable but can be reassigned to someone else if you can’t attend.

Virtual Power Platform App in a Day (AIAD) on April 21
2020-04-21 09:00 - 17:00 | Virtual Meeting
Are you looking for an agile self-service platform for automating business process that doesn’t require reliance on IT? PowerApps is a low or no-code application builder from Microsoft that gives you a way to do more with less and deliver applications to your end-users at a rapid pace. Partnering with Microsoft, Prologika is pleased to offer an 1-day instructor-led workshop covering the fundamentals of the Microsoft Power Platform which encompasses Power Apps, Power Automate, Power BI, and Common Data Services (CDS). Redesigned for digital delivery, this workshop will help you automate processes in your organization without writing code!

Attend this insightful 1-day workshop from anywhere for only $199, when Teo Lachev (CEO of Prologika, a Power BI Red Carpet Partner) teaches you practical knowledge that you can immediately apply to your job. See how Power Platform can improve your usability and productivity and transform your organization business.

Key Benefits
At the end of the day, you’ll learn how to:

Implement highly-customizable Power Apps canvas applications that can run on any device
Store and retrieve data from Common Data Services (CDS) to avoid provisioning database servers
Create model-driven apps for data entry forms and workflows
Apply Power Automate to automate business processes, such as an approval flow
Implement a Power BI model to analyze the app data
Learn best practices and get your questions answered

Agenda
The workshop will be conducted online. Login instructions will be sent to registered attendees before the event. All times are Eastern Time zone (GMT-4).
Morning
09:00 AM –10:00 AM –Introduction to Power Platform
10:00 AM –11:15AM–Lab 1 Canvas Apps
11:15AM –12:30PM –Lab 2 Common Data Service
12:30 PM –01:00 PM –Break for lunch (finish lab 2 over lunch)
Afternoon
01:00 PM –02:30 PM–Lab 3 Model-driven apps
02:30 PM –03:30 PM –Lab 4 Power Automate
03:30 PM –04:30PM–Lab 5 Power BI
04:45PM –05:00 PM–Q&A
Your Instructor
Through his Atlanta-based company Prologika (https://prologika.com), a Microsoft Gold Partner in Data Analytics, Teo Lachev helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Microsoft has awarded Teo the Most Valued Professional (MVP) – Data Platform award every year since 2004 for his expertise and contributions to the community.

Cancellation Policy
Tickets are not refundable but can be assigned to someone else if you can’t attend.

Virtual Power BI Dashboard in a Day (DIAD) on April 30
2020-04-30 09:00 - 17:00 | Virtual Meeting
Are you looking for an agile self-service BI platform that doesn’t require reporting and query skills to get basic analytics done without reliance on IT? Partnering with Microsoft, Prologika is pleased to offer an 1-day instructor-led workshop covering the end-to-end self-service BI process with Power BI. Redesigned for digital delivery, this workshop will help you understand how to analyze your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.

Register for this workshop to hone your data analytics skills! Drive value for your organization and on the road
to recovery after COVID-19. Attend from anywhere for only $199, when Teo Lachev (CEO of Prologika, a Power BI Red Carpet Partner) teaches you practical Power BI knowledge and data analytics skills that you can immediately apply to your job. See how Power BI can improve your usability and productivity even further.

Key Benefits
At the end of the day, you’ll learn how to:

Connect to, import, and transform data from a variety of sources
Define business rules and KPIs
Explore data with powerful visualization tools
Build stunning reports
Share their dashboards with their team and/or the world
Learn best practices and get your Power BI questions answered

Agenda
The workshop will be conducted online. Login instructions will be sent to registered attendees before the event. All times are Eastern Time zone (GMT-4).
Morning
09:00 AM –10:00 AM –Introduction to Power BI
10:00 AM –10:30 AM–Lab 1 Accessing & Preparing the data
10:30 AM –10:45 AM – Break
10:45 AM –11:15 AM –Lab 1 Solution + Questions
11:15 AM –11:45 AM –Lab 2 Data Modeling and Exploration
11:45 AM –12:30 PM –Lab 2 Solution + Questions
12:30 PM –01:00 PM –Break for lunch
Afternoon
01:00 PM –01:30 PM–Lab 3 Visualizations
01:30 PM –02:00 PM–Lab 3 Solution + Questions
02:00 PM –02:30 PM –Lab 4 Publishing and accessing Reports
02:30 PM –02:45 PM–Break
02:45 PM –03:15 PM–Lab 4 Solution + Questions
03:15 PM –03:45 PM–Lab 5 Building a Dashboard and Sharing
03:45 PM –04:15 PM–Lab 5 Solution + Questions
04:15 PM –05:00 PM–Q&A
Your Instructor
Through his Atlanta-based company Prologika (https://prologika.com), a Microsoft Gold Partner in Data Analytics, Teo Lachev helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes. Teo has authored and co-authored several books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Microsoft has awarded Teo the Most Valued Professional (MVP) – Data Platform award every year since 2004 for his expertise and contributions to the community.

Cancellation Policy
Tickets are not refundable but can be reassigned to someone else if you can’t attend.

Power BI Time Intelligence – Beyond the Basics
2020-05-04 06:30 - 20:30 | Virtual Meeting
Time-Intelligence refers to analyzing calculations and metrics across time and is the most common type of business intelligence reporting. Power BI has a lot of built in capabilities to help you get started but these alone are not always enough for most real-world solutions. The key to mastering time-intelligence in Power BI is a good date table and understanding how to manipulate the filter context. This session will teach you how to do both!
In this (demo-heavy) session, we’ll quickly review Power BI’s built-in time intelligence capabilities and why you should avoid them! We’ll also cover the importance of a good date table, what attributes it should include, and how it can be leveraged to simplify complex time-intelligence calculations. Finally, we’ll breakdown a handful of the 40+ DAX time-intelligence functions, showing you how they work under the covers (hint: filter context) and how they can used in combination to accommodate complex business logic.
