Archive

SQL Tips

  Back Delete specific rows from a table with hundreds of millions of records fast Join Types  

PBI Tips

From my 3 years of experience, creating dashboards for different clients in the organization and outside of it these are some of things I have learned. Make use of Power BI templates: Power BI has a number of templates that can help you get started ...

SSIS Tips

From my 10 years of experience working with SSIS these are some factors to consider while working on SSIS projects: Plan your SSIS project: Before starting your SSIS project, take the time to plan out your data flows, package dependencies, and overall project architecture. This ...

BI Management Tips

Some tips about BI management: Define clear goals and objectives: Start by defining clear goals and objectives for your BI initiative. This will help ensure that you are focusing your efforts in the right areas and working towards a common goal. Enroll your client in ...