Power BI Workshop July 23

Introduction to Power BI - 90 minutes of WOW! - July 23 - Workshop

Power BI Workshop July 23

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

Agenda

  1. Introduction to Power BI
  2. Get Data
  3. Advanced Transformations with Power Query formula Language M
  4. Data Modelling, Data Analysis Expression (Q&A)
  5. Data Visualization
  6. Power BI Website
  7. Power Q&A
  8. Administration and Security in Power BI

Details

Date:
July 23, 2019
Time:
1:30 pm - 3:00 pm - ET EDT
Event Categories:
,

Venue

Best Western Dixie and 401
5825 Dixie Road
Mississauga, ON L4W 4V7 Canada
+ Google Map
Phone:
647-849-3801

Best Western Plus Toronto Airport Hotel

5825 Dixie Rd,

Mississauga,

ON L4W 4V7

5825 Dixie Rd, Mississauga, ON L4W 4V7

Microsoft PowerBI

Top 5 power features of Microsoft Power BI you should know

Microsoft Power BI is a modern tool for business analytics. It empowers users with real-time insight into what is happening. With Power BI, you can create personalized dashboards “in no time” and find answers to the most important questions for your business. Power BI provides cloud-based BI services along with desktop version. Microsoft releases new features and updates for Power BI very frequently to improve performance.

Just in 2018 alone, over 150 features were released in terms of analytics, modelling, custom visualizations, data connectivity, data preparation and reporting. Here are the top five features picked by Vox ISM’s Power BI team for 2018.

Microsoft PowerBI

  1. Report page tooltips

It gives user the flexibility to customize the tooltips when hovering over other visuals. Think of it as a drill down without having to actually drill down. If you hover over a data point on a line graph for example you can see a whole new report about that particular data snippet.

(https://docs.microsoft.com/en-us/power-bi/desktop-tooltips)

  1. Web by example

You can consistently extract data directly from web pages with sample selections to target the larger data set you wish to extract. Typically this was a difficult task due to diversity in website design, but with this tool you can still get your industry trends/insights from the web.

(https://docs.microsoft.com/bs-latn-ba/power-bi/desktop-connect-to-web-by-example?view=azdevserver-2019)

  1. Composite models + aggregations

New aggregation feature allows to cache the data at the aggregated level and gives users a great user experience with huge datasets. It provides instantaneous insights with almost six trillion rows.

(https://docs.microsoft.com/en-us/power-bi/desktop-aggregations)

  1. Expand + collapse

This feature allows users to drill down the levels and it is one of the most requested features

(https://docs.microsoft.com/en-gb/power-bi/visuals/desktop-matrix-visual)

  1. New filter experience

You can format, customize, hide and lock the filters. Now you have the ability to see what filters or slicers are applied to the report.

(https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview)

Apart from these eminent features, Microsoft released various Accessibility features like add filters to the context menu, ability to see hex values if you hover over the colours, keyboard shortcut dialogue so that you don’t have to remember shortcuts. Overall 2018 was a good year in terms of features, but we look forward to new features related to Business intelligence and intuitive insights in 2019.

Interested to know more about Microsoft Power BI:

Join us for an exclusive webinar on January 16 to learn more about Vox ISM Industry Specific Power BI solution – MARS – Management Analytics Reporting Suite. Click here to register.

 

Blog post by Emilia Arkadyev and Vasudha Solanki.

Emilia Arkadyev_Vox ISM

Emilia Arkadyev- Solutions Architect, Development Manager

Emilia has been with Vox ISM for over 11 years. Her current role with Vox ISM is focused on solution architecture, business intelligence, integrations and data management.  Emma has 25 years of experience and the successful completion of hundreds of projects.

Vasudha Solanki_Vox ISM

Vasudha Solanki- Project Manager

Vasudha is a Project Manager at Vox ISM, her current role is focused on Client relationship building and successful project delivery. She will be the active communication link between the customer and all project stakeholders.


Microsoft Dynamics 365 PowerBI - Key Features

Microsoft Dynamics 365 PowerBI - Key Features

Please join us on November 13, 1:30 PM – 3:30 PM at our Customer Appreciation Seminar in Mississauga. Click here to RSVP.  We will be showing you the latest release of Microsoft Dynamics Business Central – NAV, Dynamics 365 – CRM, and Business Intelligence.  Join Vox ISM, our Dynamics 365 Experts, keynote speakers, and our special guests.  We will be discussing the following:  USMCA (formally called NAFTA); CAMM, ASCIP, Microsoft and Vox ISM’s APPS; Cyber Security; COJG (Government Funding); and how they can benefit manufacturing companies.

Living Arts Centre
Rogers Theatre
4141 Living Arts Dr,
Mississauga, ON L5B 4B8

Dynamics 365 Business Central is a business management solution that helps companies connect their financials, sales, service, and operations to streamline business processes, improve customer interactions, and make better decisions, in real time.

In this blog, we will outline some of the Microsoft Dynamics 365 – PowerBI (Business Intelligence and AI) agenda items.

Worldwide, the manufacturing industry is highly competitive and evolves quickly.  Microsoft Dynamics 365 provides you with a 365 degree view of your customers, tracking your field and project services, giving you the intelligence to improve your decision making process.


Evolution of Management Reporting

Microsoft Dynamics PowerBI_Evolution of Data Awareness

Artificial intelligence continues to drive the conversation for manufacturing companies as they are demanding automated and ease-of-use solutions powered by machine learning and other IoT technology. As a result, top manufacturers have made AI a priority while staying focused on CRM fundamentals.  Come to see firsthand how your business can keep in touch with analytics, operate faster, be L.E.A.N. by being more cost-effective with a more personalized customer experience.

Excel Analysis Cubes – Supply Chain, Purchasing, Manufacturing Jobs, and Sales

Microsoft Dynamics PowerBI_2

Join us at our November 13 Customer Appreciation Seminar at the Living Arts Centre in Mississauga, Ontario, we will show you how you how easy it is to use Microsoft PowerBI to get the information that is important to you.  Allowing you to make informed and intelligent decisions in real time.  Best of all it is free with the purchase of Microsoft Dynamics 365.  We at Vox ISM, look forward to discussing Microsoft Dynamics 365 – PowerBI with you and your manufacturing team.

Power BI – Make Data Driven Decisions

Microsoft Dynamics PowerBI_3

Blog post by Linda Heaton – Marketing Specialist. 

Linda Heaton_Vox ISM

Linda Heaton is Vox ISM’s most experienced marketing specialist. She has been with Vox ISM for 20 years and has touched every piece of marketing material that has gone through Vox ISM in that time. Linda has been an integral part in Vox ISM’s continued drive towards increasing sales while lowering cost per lead. Many of our customers and prospects will know Linda as she is actively engaged in our webinar and event coordination.