Microsoft Power BI UK User Group – Learning M Using the UI With Matt Allington

https://youtu.be/bhh5CxykEsA

Join our Microsoft Power BI – UK User Group for our webinar in association with Onyx Data (onyxdata.co.uk). This session we are excited to announce our host Leon Gordon will be introducing Microsoft MVP Matt Allington.

Join the Microsoft Power BI UK – User Group on –

Microsoft Community – https://community.powerbi.com/t5/Power-BI-UK-User-Group/gh-p/pbi_UK_usergroup
LinkedIn – https://www.linkedin.com/groups/8909321/
MeetUp – https://www.meetup.com/microsoft-power-bi-uk

Session Abstract

Power Query is a fabulous tool for cleansing and then loading data into Power BI and Excel. The UI is excellent and it lets you do almost everything you can imagine just by clicking on the menu options. Yet under the hood of Power Query is a very powerful functional language called “M”. There is now Intellisense that supports the M language in the UI, but you can also learn a lot about how the language works by using the UI to teach you. In this session I introduce the basics of the M language and demonstrate concepts on how to learn more as you write you queries.

Biography
Matt Allington is a career expert in BI and has had more than 30 years’ experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Query and Power Pivot for Excel. He combines his business and IT experience together to deliver training, consulting and general business data problem solving to clients worldwide. Matt is the author of the best-selling book “Supercharge Power BI – Power BI is Better When You Learn to Write DAX” and has a very popular blog at xbi.com.au/blog

Social Media / Website Links
https://xbi.com.au/blog
https://twitter.com/ExceleratorBI
https://www.linkedin.com/in/mattallington/

What Does Power BI Allow You to Do?

Many businesses revolve around data. Strategists comb through data to discover customer trends and guide decisions. Data helps business owners make smarter choices, but analysing many data points can get overwhelming. 

Microsoft created Power BI to help visualise raw data. We’ll explore ways you can use this business intelligence tool to gain new insights.

Data Organisation

Power BI takes clusters of data and provides structure. You can connect multiple platforms into a central hub and see how the data connects. Power BI integrates with Google Analytics, Microsoft Dynamics, Salesforce, and other resources.

Real-Time Updates to Your Data

Some business owners log into each data analytics account to stay updated on real-time movement. Instead of keeping multiple tabs open and shifting through them, Power BI provides real-time updates for all data.

Real-time updates in a single hub help you identify and solve problems quicker. Taking action on real-time data helps businesses launch new projects sooner. These new projects then provide more data, leading to more data-driven decisions. 

Data Protection

Power BI gives you many data points, but this tool also protects it from hackers. Security features such as row-level security access filters restrict data access. You can limit team members to specific data points to ensure they only see data they’re meant to see.

As cyberattacks become more prevalent, keeping your data safe is vital. Power BI acts as a reliable companion while making your data easier to understand.

Work Smart Instead of Hard

Data helps us work smart instead of only working hard. You can review traffic data to discover how people engage with your content and optimise each customer journey stage. 

Power BI takes the guesswork out of your business. The data will reveal your company’s opportunities for growth.

Save Money

Some businesses use Power BI to gain more insights into ad performance. They can track clickthrough and conversion rates to discover underperforming ads. Distinguishing ad performances helps companies to save money and get more leads.

Power BI lets you track the data across each stage of your business. Instead of only having Google Analytics data, you can simultaneously view Salesforce data. You can review how people convert across your funnel.

Use Power BI to Grow Your Business

Data helps businesses make better decisions that impact revenue. Power BI assembles a company’s data into a central hub and provides visual insights. This resource can grow your business, but having the right team behind you can make all of the difference. 

Our Power BI consultancy can assist with setting up real-time updates and growing your business with this business intelligence tool. We know how to curate your data and provide compelling insights for your business. Contact us today to see how we can help your business.

Microsoft Power BI UK User Group – Intro into Power BI Premium Per User With Gilbert Quevauvilliers

https://youtu.be/g5Bp-Bi6XoY

Join our Microsoft Power BI – UK User Group for our webinar in association with Onyx Data (onyxdata.co.uk). This session we are excited to announce our host Leon Gordon will be introducing Microsoft MVP Gilbert Quevauvilliers.

Join the Microsoft Power BI UK – User Group on –

Microsoft Community – https://community.powerbi.com/t5/Power-BI-UK-User-Group/gh-p/pbi_UK_usergroup
LinkedIn – https://www.linkedin.com/groups/8909321/
MeetUp – https://www.meetup.com/microsoft-power-bi-uk

Session Abstract
Whilst there has been a lot of interest in Power BI Premium it has been a challenge to see and understand what Power BI Premium features are available.

In this session I will cover an introduction into how Power BI Premium works, and then explain and demo some of the latest features and the differences with Power BI Premium Per User
• Free users
• Incremental Refreshing
• Paginated Reports
• XMLA End Points
• AI Insights
• If time allows deployment pipelines, usage based aggregation

Any other features you wish to explore

Speaker Bio
Power BI & Data Analytics Consultant at FourMoo I have 10+ years delivering data solutions.
I have been using Power BI since it’s first inception at the end of 2014, and I have a real passion for Power BI. I have been using DAX from Excel 2010 when it was created. Microsoft MVP (2017-2020) Hand on experience assisting organizations (small to enterprise) in the successful implementations using Power BI & the Microsoft Data Analytics Platform.
Expertise include Azure (Azure Analysis Services, Function Apps, Runbooks, Automation Accounts, SQL Server less DB, Azure Data Lake) and On-Premise Microsoft Platform 2005-2019 (SQL Server, Integration Services, Analysis Services Multidimensional and Tabular, Reporting Services) Fortunate to have spoken at various events (Microsoft Business Applications Summit, SQL Saturday’s, Power BI User Groups & more)

@gilbertQue
www.fourmoo.com
gilbert@fourmoo.com