The C-Suite trusts our experts to equip and empower their enterprise with agile and intelligent strategies and services that get results.
Collectiv is a full-service firm that covers any and all enterprise requirements around analytics, planning, and AI for the entire Microsoft data ecosystem.Menu
Our industry-leading programs are designed to impart years of learnings, implementations, and experiences to help your team.Menu
- ResourcesJBT wanted to further evolve their enterprise by building a robust reporting solution. Collectiv’s Visioning Program helped them find the best path forward.You paid for Power BI licenses. Now what? Our Power BI training ensures everyone on your team is successful wherever they are in their Power BI journey.
- Company“What makes this company special is the people and the culture. Unlike other previous jobs I've had, working at Collectiv has given me an immense amount of flexibility and fulfillment. I feel like my contributions are valued and that my work is recognized. I love what I do here.”“Collectiv allows me to live my life with complete freedom from time and location requirements while allowing me to apply my experience gained throughout my career. I am continuing to develop technical, managerial, and financial acumen through partnerships with my colleagues to meet the needs of my clients.”“Collectiv does an excellent job creating a clear path of communication throughout the organization. Collectiv has expanded my knowledge base by giving me the opportunity to work on innovative projects. I am excited to continue to learn with Collectiv and provide exceptional service to clients.”“Collectiv offers an exciting and challenging environment with a wide variety of projects and companies I’ve never had the opportunity to experience before. This is the type of remote workforce I’ve always wanted to be a part of, a place where I can develop my passions, skills, and talents.”
We are a people-centric Power BI consulting and strategy firm. When your team needs a skilled helping hand, Collectiv is your go-to partner.Menu
- This event has passed.
Power Query M Code- Power BI Foundations Training
June 11, 2020 @ 9:00 am - 10:30 pmFree
Want to clean and mash-up your data for Power BI?
Then you need to know how to use Power Query M code in Power BI
In this free training, we will cover Power Query M code and the advanced editor specifically writing M code using Intellisense, creating M functions to be used in other queries, creating dynamic formulas to take into account changes in datasets being imported into Power BI and working with parameters.
In real life, your dataset for Power BI will not be clean, so it is important to have the knowledge when it comes to data cleansing we will show you some advanced techniques and tricks.